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?
... View more