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

[dugganisrivani]

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?

[PickleRick]

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

[dugganisrivani]

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

[PickleRick]

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.

[dugganisrivani]

Can you  please share  how it is done?