Hi Team,
Im trying below expression in query def I actually want to try using contains instead of like
Iif(@label LIKE '%labelname1%' OR @2449631 LIKE '%labelname2%','A1' ,Iif(@label LIKE '%labelname3%' OR @2449631 LIKE '%labelname4%','A2','A3' ) )
Could you please help us with correct syntax.
Hi @vanivi1 ,
You can utilize the 'Charindex' function in expression as below:
Iif(Charindex(@label, 'labelname1') > 0 OR Charindex(@label, 'labelname2') > 0,'A1' ,Iif(Charindex(@label, 'labelname3') > 0 OR Charindex(@label, 'labelname4') > 0,'A2','A3' ) )
The above expression will result the value 'A1' if the label contains 'labelname1' or 'labelname2' and the result will be 'A2' if the label contains 'labelname3' or 'labelname4'. For all the other labels, 'A3' will be the default value.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.