Compare string of two columns

[victor_greffet]

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]

Try this.

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

From xyz;

Regards,

Kaushik Solanki

[victor_greffet]

Hi Kaushik Solanki,

Thks for your answer

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

[sarafamiglietti]

Hello,

You can use the Wildmatch function

wildmatch ‒ QlikView

-> So in you case

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

Regards

[surendraj]

something like

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