topic Re: Splunk LOOKUP in Splunk Cloud Platform

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

dugganisrivani — Tue, 03 Jan 2023 16:13:15 GMT

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?

Re: Splunk LOOKUP

PickleRick — Tue, 03 Jan 2023 11:35:19 GMT

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

Re: Splunk LOOKUP

dugganisrivani — Thu, 05 Jan 2023 11:03:12 GMT

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

Re: Splunk LOOKUP

PickleRick — Thu, 05 Jan 2023 11:58:00 GMT

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.

Re: Splunk LOOKUP

dugganisrivani — Mon, 09 Jan 2023 05:45:28 GMT

Can you please share how it is done?