<p>Hi,</p>
<p> </p>
<p>I have a JDBC data set and in the DB there's a table that contains 'extensions' for another table. I'm currently collecting these extensions to a globalPersistentVariable.</p>
<p>Is it possible to iterate this variable after it has been fetched and then add columns to another data set based on these values?</p>
<p> </p>
<p>To clarify:<br><br>
Let's say there's a table containing cars that are unique.</p>
<p>There's also an extension table that contains owners and dates for that car (identified by car_id)</p>
<p> </p>
<p>I want to add these owners to the car data set, but I can't join them as multiple owners would lead to multiple rows for the same car in the data set, right? <br><br>
Is it possible to collect the owner data (lets say only the names) and then add it as columns for a single car or is there a more simple / better way of implementing this?</p>
<p> </p>
<p>Thanks,</p>
<p>Arto </p>
<p>
</p>
