Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have one requirement
I have dataset with columns parts and code
I need to add new country column in script like :
if any of the code = 34 or 35 country = Canada
if any of the code =14, 20 OR 43 country = Mexico
if any of the code = 34 or 35 and 14, 20 OR 43 country = Both
all this should be appear as country column
Please help
Thanks in advance
Hi,
try this
,if(WildMatch(code, 34,35), 'Canada'
,if(WildMatch(code, 14,20,43), 'Mexico'
,if(WildMatch(code, 34,35) AND WildMatch(code, 14,20,43), 'Both'))) as country