Check if column value is in list a list of values

[razvan_brais]

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

[tresesco · Accepted solution]

If you are trying to create a flag field, it looks okay to me. Isn't it working for you?

[razvan_brais]

It was working. I don`t know why I had issues on seeing them .

Thanks a lot

[Amit]

Perfect Answer