Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I tried to create a if statement that separates customers and employees based on ActorEmployee_ID
so if someone has a ActorEmployee_ID that is one of the values in vSupport then its a Employee in Type. Else its a Customer my if statement does not compile I get a error. Any ideas, should I use a mapping table instead?
SET vSupport=('523','2203','1009','2185','2405','2186','1801','509','2202');
If(ActorEmployee_ID=$(vSupport),Employee,'Customer') as Type,
Thanks,
Its solved with this code
if(index('$(vSupport)',ActorEmployee_ID)>0,'Employee','Customer') as Type
May be try this:
SET vSupport='523','2203','1009','2185','2405','2186','1801','509','2202';
If(Match(ActorEmployee_ID, $(vSupport), Employee, 'Customer') as Type,
Hi,
I would try using FOR EACH loop on vSupport. Which will run through each value in vSupport , it will identify whichever value to be classify as Employee or Customer. Store each value for Employee or Customer in a Temp Tbale and use Peek function to pick them back and use it wherever you wish.
FOR EACH vSupport IN $(vSupport)
IF vSupport = whatever employee value is then
EmpTable:
LOAD
$(vSupport) AS EmpVlaue
AUTOGENERATE 1;
Something like that
Thanks,
Its solved with this code
if(index('$(vSupport)',ActorEmployee_ID)>0,'Employee','Customer') as Type
Hi Sunny I got the solutions posted down, I could not execute your script though but tour idea with the match helped