Discussion Board for collaboration related to QlikView App Development.
Hi, I have a data set like
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
mapping LOAD *,'_Good_' as Flag Inline [
if(not wildmatch(MapSubString('Map_part',part),'*_Good_*'),'Bad Part') as MapPartFlag
View solution in original post
index(Part_Number, Market_Part_Number) = 0 as BadFlag
This worked! Thank you for the quick answers!