Match () with variable values

[Sara_3]

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?

[vinieme12 · Accepted solution]

this works

SET vPartNumIndicator = '1F*','90*','91F*','*GS*';  << remove space

temp:
Load PartNumber, If(WildMatch(PartNumber,$(vPartNumIndicator)),1,0) as Flag  << use wildmatch
Inline [
PartNumber
1Fsksks
91Fwrwerw
abcwefwef
yesno
];

output

[Sara_3]

Thanks yes wildmatch works !

[vinieme12]

happy to help