https://communities.sas.com/t5/SAS-Data-Management/DataFlux-SQL-Lookup/m-p/584695#M17885 Hi<BR /><BR /><BR /><BR />If you need to build more complex SQL Lookup you can use the "Parameterized SQL" node, ie Select description from mylist where id = ? and version = ?". Next the parameters have to be passed in the exact same order. Wed, 28 Aug 2019 17:59:55 GMT VincentRejany 2019-08-28T17:59:55Z https://communities.sas.com/t5/SAS-Data-Management/DataFlux-SQL-Lookup/m-p/584246#M17865 <P>Hello,</P><P>&nbsp;</P><P>I have 2 questions below related to DataFlux Data Management Studio 2.6</P><P>&nbsp;</P><OL><LI>Is it possible to specify AND condition on multiple data elements or fields in SQL lookup e.g id=id1 and status=status1</LI><LI>I have a data job which has 10 SQL input nodes(runs same SQL) which selects data from 10 different schemas and has same table structures. During testing, I need to just run one node vs all 10 nodes, is it possible to exclude 9 nodes from execution and run only one input node? This is needed to test job which deals with higher volume of data.&nbsp;</LI></OL><P>&nbsp;</P><P>Please let me know if you have any questions and need additional information.</P><P>&nbsp;</P><P>Best regards,</P><P>Chetan</P> Tue, 27 Aug 2019 14:16:09 GMT https://communities.sas.com/t5/SAS-Data-Management/DataFlux-SQL-Lookup/m-p/584246#M17865 Che 2019-08-27T14:16:09Z https://communities.sas.com/t5/SAS-Data-Management/DataFlux-SQL-Lookup/m-p/584695#M17885 Hi<BR /><BR /><BR /><BR />If you need to build more complex SQL Lookup you can use the "Parameterized SQL" node, ie Select description from mylist where id = ? and version = ?". Next the parameters have to be passed in the exact same order. Wed, 28 Aug 2019 17:59:55 GMT https://communities.sas.com/t5/SAS-Data-Management/DataFlux-SQL-Lookup/m-p/584695#M17885 VincentRejany 2019-08-28T17:59:55Z