db looping

[ipazin]

Hello @Jeff,

DB Looping is a way to go in your case. You just have to get the syntax right.

@Jeff

is #table# is my example the transactions table (how to I ensure it is?)

If the table place holder isn’t changed, then it will be replaced with the query from the database input port. So if you connect DB Table Selector node it will take selected table.

@Jeff

Then do I add to query where transaction.customer_id in ($customer_id$) <from spreadsheet?>

Yes.

Here is screenshot for better understanding:

Hope this helps!

Br,
Ivan