Finding a string as a substring of another

[BaNANA]

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?

[Kushal_Chawda · Accepted solution]

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 ];

[rwunderlich · Accepted solution]

index(Part_Number, Market_Part_Number) = 0 as BadFlag

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

[BaNANA]

This worked! Thank you for the quick answers!