Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey guys,
I was wondering if what I`m doing , I`m doing it wright .
I would like to create a variable in script , which contains multiple values and after that to check if a column value is in that list.
What I have done is this :
set vListOfExceptions2 = '1','2','3','4','5';
load
ID,
Value,
if(match(ID,$(VListOfExceptions2)),'Needed2') as NeededStuff2,
DATE,
Year(DATE) as Year,
Resident Table;
I want to know if this is ok , and it will check if the ID equals one of the values from the variable. If not , how can I do that?
Thanks,
Razvan
If you are trying to create a flag field, it looks okay to me. Isn't it working for you?
If you are trying to create a flag field, it looks okay to me. Isn't it working for you?
It was working. I don`t know why I had issues on seeing them .
Thanks a lot
Perfect Answer