Splunk Cloud Platform

Can we use a lookup table to replace in the case like statements?

dugganisrivani
Observer

Can we use a lookup table to replace in the case like statements? 
For Example:
          index="example"| eval ErrorMessage=case(like(Errormessage,"%Bad Connection%"),"Check Your Connection",
              like(Errormessage,"%Wrong Password%"),"Please check the password",
              like (Errormessage,"%Invalid code%"),"Please enter a valid code", 1=1,"NEW Error")

When the query is like this can we use look up table where if we found the message in A column which contains % wildcards we need to replace it with the one in the B column which has the fixed value?

Labels (1)
0 Karma

PickleRick
SplunkTrust
SplunkTrust

Yes, you can have a lookup with wildcard match type.

0 Karma

dugganisrivani
Observer

Can you please share how the syntax would be to use the lookup table?

 

0 Karma

PickleRick
SplunkTrust
SplunkTrust

It's not about how you use the lookup. It's how the lookup is defined. You must have this lookup defined with the particular match type. Otherwise you cannot match with wildcards.

0 Karma

dugganisrivani
Observer

Can you  please share  how it is done?

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...