I have a field name [Part Number ] , when it selected i need to check if [Part Number ] is match with given Part numbers in variable so 1 otherwise 0.
i create a SET variable:
SET vPartNumIndicator = '1F*' , '90*' , '91F*' , '*GS*';
in load editor I create if statement:
If(Match([Part Number ] ,$( vPartNumIndicator)),'1,'0') as Flag
It does not work , anyone has an idea why?