Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 ];
index(Part_Number, Market_Part_Number) = 0 as BadFlag
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
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 ];
index(Part_Number, Market_Part_Number) = 0 as BadFlag
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
This worked! Thank you for the quick answers!