topic Re: Finding a string as a substring of another in QlikView

Finding a string as a substring of another

BaNANA — Thu, 16 Jan 2020 21:30:24 GMT

Hi, I have a data set like

Part_Number Market_Part_Number

ABC AB

BCDE BCD

I want to make sure that Market Part Number is always substring of Part_Number, If not I have to flag it out as bad data.

Can someone please help me how to do it in Qlik Script side or Expression?

Re: Finding a string as a substring of another

Kushal_Chawda — Thu, 16 Jan 2020 21:54:41 GMT

something like below

Map_part: mapping LOAD *,'_Good_' as Flag Inline [ market_part AB BCD FG ]; Data: LOAD *, if(not wildmatch(MapSubString('Map_part',part),'*_Good_*'),'Bad Part') as MapPartFlag Inline [ part,market_part ABC,AB BCDE,BCD ACD,FG ];

Re: Finding a string as a substring of another

rwunderlich — Fri, 17 Jan 2020 02:04:22 GMT

index(Part_Number, Market_Part_Number) = 0 as BadFlag

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Finding a string as a substring of another

BaNANA — Fri, 17 Jan 2020 17:28:08 GMT

This worked! Thank you for the quick answers!