topic Re: Compare string of two columns in App Development

Compare string of two columns

victor_greffet — Wed, 31 Jan 2018 15:06:46 GMT

Hi community,

I'd like to flag if the string of one column appear in an other column and count them in KPI, something like that (in the visual mode)

ID	DepartmentA	DepartmentB	flag
1	Ain	xxxxAinxxx	ok
2	Cantal	xxxxxxxxxxx	nok
3	Garonne	xxxxxxxxxx	nok
4	Aveyron	xxxxAveyron	ok
5
...

I tried :

--> If(WildMatch(DepartmentA,'*'&DepartmentB&'*'),'Ok','nOK') as Flag

--> If(Substringcount(DepartmentA,'*'&DepartmentB&'*')<>1,'Ok','nOK') as Flag

--> If(WildMatch('*'&DepartmentA&'*',DepartmentB),'Ok','nOK') as Flag

--> If(Substringcount('*'&DepartmentA&'*',DepartmentB)<>1,'Ok','nOK') as Flag

--> If(WildMatch('*'&DepartmentA&'*','*'&DepartmentB&'*'),'Ok','nOK') as Flag

--> If(Substringcount('*'&DepartmentA&'*','*'&DepartmentB&'*')<>1,'Ok','nOK') as Flag

Without success...

Do you have an idea ?

Thanks !

kaushiknsolanki — Wed, 31 Jan 2018 15:19:51 GMT

Try this.

Load *,If(Substringcount(DepartmentB,DepartmentA)=1,'Ok','nOK') as FLag

From xyz;

Regards,

Kaushik Solanki

victor_greffet — Wed, 31 Jan 2018 15:40:07 GMT

Hi Kaushik Solanki,

Thks for your answer

unfo with your formula the Flag ok appear only if DepartmentB=DepartmentA....

sarafamiglietti — Wed, 31 Jan 2018 15:49:21 GMT

Hello,

You can use the Wildmatch function

-> So in you case

if(WildMatch(DepartmentB, '*'&DepartmentA&'*'),'OK','NOK')

Regards

surendraj — Wed, 31 Jan 2018 16:38:17 GMT

something like

if(Match(DepartmentA,'*DepartmentB*','OK'),'NOK')