https://community.qlik.com/t5/Talend-Studio/how-to-compare-a-list-in-tmap/m-p/2321861#M91857 Hi Shail, <BR />you can do it with a common lookup in tMap component. <BR />Use tRowGenerator to create a flow, fixed with elements, those you want search in. <BR />Than use this flow as a standard lookup (inner or outer) in tMap. <BR />May help <BR />Bye Wed, 06 Apr 2016 09:51:15 GMT gorotman 2016-04-06T09:51:15Z https://community.qlik.com/t5/Talend-Studio/how-to-compare-a-list-in-tmap/m-p/2321860#M91856 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 <BR />CASE WHEN A IN (1,2,3,4,5,16,20,65) THEN 1 ELSE 0 END <BR />I am trying to implement the same in Talend's Tmap component but I have no idea how to do this.Please help. <BR />Thanks, <BR />Shail Wed, 06 Apr 2016 02:57:19 GMT https://community.qlik.com/t5/Talend-Studio/how-to-compare-a-list-in-tmap/m-p/2321860#M91856 Anonymous 2016-04-06T02:57:19Z https://community.qlik.com/t5/Talend-Studio/how-to-compare-a-list-in-tmap/m-p/2321861#M91857 Hi Shail, <BR />you can do it with a common lookup in tMap component. <BR />Use tRowGenerator to create a flow, fixed with elements, those you want search in. <BR />Than use this flow as a standard lookup (inner or outer) in tMap. <BR />May help <BR />Bye Wed, 06 Apr 2016 09:51:15 GMT https://community.qlik.com/t5/Talend-Studio/how-to-compare-a-list-in-tmap/m-p/2321861#M91857 gorotman 2016-04-06T09:51:15Z