Retrieve data via SQL connection using the data during run timeRetrieve data via SQL conne

[RajatK]

Hi,

I have a situation wherein I am trying to retrieve SQL data during run time and the filters for the SQL statement depend of the data flowing out of one of the tools (during run time).

These are the 19 records which are outputted from one of the Sort tools and this needs to be further used to edit an SQL script which would read something like this:

Select * from TABLE_NAME where company_code in ('2R,'SC','B118',.....) and account_number in ('10120','10127',....) and functional_currency in ('USD',CRC',.....)

Any insights would be helpful. Thanks :)

[geraldo · Accepted solution]

@RajatK 

An example workflow follows. Make necessary adjustments for data and test connections. I believe this is the way to go.

[RajatK]

@geraldo, wow! This is super helpful. Thank you!