This content has been marked as final.
Show 4 replies
-
Re: Compare string of two columns
Kaushik Solanki Jan 31, 2018 10:19 AM (in response to Victor GREFFET )Try this.
Load *,If(Substringcount(DepartmentB,DepartmentA)=1,'Ok','nOK') as FLag
From xyz;
Regards,
Kaushik Solanki
-
Re: Compare string of two columns
Victor GREFFET Jan 31, 2018 10:40 AM (in response to Kaushik Solanki )Hi Kaushik Solanki,
Thks for your answer
unfo with your formula the Flag ok appear only if DepartmentB=DepartmentA....
-
Re: Compare string of two columns
Sara Famiglietti Jan 31, 2018 10:49 AM (in response to Victor GREFFET )Hello,
You can use the Wildmatch function
-> So in you case
if(WildMatch(DepartmentB, '*'&DepartmentA&'*'),'OK','NOK')
Regards
-
-
-
Re: Compare string of two columns
surendra j Jan 31, 2018 11:38 AM (in response to Victor GREFFET )something like
if(Match(DepartmentA,'*DepartmentB*','OK'),'NOK')