Not good at load scripts!

[#1]

I am sure this will be an easy question for most of you but I can not figure out the syntax of the if statement in my load script....

If the referral status ID equals 100 OR 200 then I want to flag it with a 1!

IF(REFERRAL_STATUS_ID <> ('100','200') ,1,0)

...I am not good at coding!

[Gysbert_Wassenaar · Accepted solution]

if(match(REFERRAL_STATUS_ID,100,200),1,0) as Flag

If you want the opposite switch around the 1 and 0.

[#3]

Thank you, I have not used Match before!

[israrkhan]

hi, try this

IF( REFERRAL_STATUS_ID = 100 OR REFERRAL_STATUS_ID = 200 ,1,0) AS Flag.

Hope it help...

Khan