Pick - match with 2 columns

[priyarane]

Hi Community,

is there any way to compare 2 columns with pick - match function for below expression for ex

if(Dim1='A' or Dim2= 'B','X') as Test

-Priya

[sunny_talwar · Accepted solution]

May be this

Pick(WildMatch(Dim1&'|'&Dim2, 'A|*', '*|B') + 1, 0, 1, 1) as Test

So, the above will assign 1 when Dim1 = 'A' or Dim2 = 'B', for rest other the Test = 0