how to create a variable script

[dmxmikey]

I have below script and would like to output word Gluten, if its either C or  P or M

M2_Allergens:

left join (Allergy_tmp)

Load

[p-code],

/

if(Gluten='C' or 'P' or 'M','Gluten')  as M2_Allergens

Resident Allergy_tmp;

[Anil_Babu_Samineni · Accepted solution]

Title looks like you need variable,

M2_Allergens:

left join (Allergy_tmp)

Load

[p-code],

/

if(Match(Gluten,'C' , 'P' , 'M'),'Gluten', Gluten)  as M2_Allergens

Resident Allergy_tmp;