pentaho add list to a SQL where in clause
<p>I have a Penthao transformation in which the output column from a sql query from a database needs to be inserted as a list in a query on another database in the where in ([list]) clause. This in step would be</p>

<ol>
<li>run query on db1  </li>
<li>turn the column into a list pass this list inside</li>
<li>pass this list inside the where clause of the second query</li>
</ol>

<p>I understand this may not be a straightforward question but if somebody understand where I am struggling, at least pointing me to the right direction may be very useful.</p>

<p>Thanks,</p>