Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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",
if(index('$(vSupport)',ActorEmployee_ID)>0,'Client','Customer') as Type,
if(index('$(vSupport)',ActorEmployee_ID)>0,'Client','Customer') as Type,
Worked as a charm thanks