If statment in load script with set value

[#1]

I want to separate the customers from clients by ActorEmployee_ID. So if a person has a ActorEmployee_ID that is in vSupport it should be a client, else a customer.

Any my script does not work, any ideas?

SET vSupport=('523','2203','1009','2185','2405','2186','1801','509','2202');

If(ActorEmployee_ID=$(vSupport),Client,'Customer') as "Type",

[m_woolf · Accepted solution]

if(index('$(vSupport)',ActorEmployee_ID)>0,'Client','Customer') as Type,

[#3]

Worked as a charm thanks