Multivalues into variable to use in load statement

[latheesh]

Hi, Anyone can help on this.

I need to put the values (ex: product id) into a variable and the variable needs to be passed through where clause to fetch the data from DB.

Values to the variables is in an excel and the values will be dynamic and more than 500. The file will get updated from some other application. So that I cannot go with inline. Please help.

Thanks.

[vinieme12]

Use Exists()  or  INNER KEEP  to restrict the data

[latheesh · Accepted solution]

Thanks for your input.

It worked for me through another approach.

Concat(Distinct char(39) & "productid" & char(39),',') as allproducts

Resident table;

Then creating a var with peek and this can be passed as input for another load script.

Let vProduct=Peek('allproducts');

Thanks.