how to compare a list in tmap

One Star

how to compare a list in tmap

I have a scenario where I am comparing column A with a list of constant numbers, which is easily possible in SQL using IN statement like
CASE WHEN A IN (1,2,3,4,5,16,20,65) THEN 1 ELSE 0 END
I am trying to implement the same in Talend's Tmap component but I have no idea how to do this.Please help.
Thanks,
Shail
Six Stars

Re: how to compare a list in tmap

Hi Shail,
you can do it with a common lookup in tMap component.
Use tRowGenerator to create a flow, fixed with elements, those you want search in.
Than use this flow as a standard lookup (inner or outer) in tMap.
May help
Bye