DB Looping

This node runs SQL queries in the connected database restricted by the possible values given by the input table. It restricts each SQL query so that only rows that match the possible values from the input table are retrieved whereas the number of values per query can be defined. This node is usually used to execute IN queries e.g. SELECT * FROM table WHERE Col1 IN ($Col1_values$) where #Col1_values# will be replaced by a comma separated list of values from the input table.

Input ports

1. Type: Table
   Data table with possible values
   KNIME data table with possible values used to constrain the database SQL query.
2. Type: DB Data
   DB Data
   DB Data that will be used during query execution.

Output ports

1. Type: Table
   Result Table
   KNIME data table with the result from the database and optionally the data columns from the input table.
2. Type: Table
   Error Table
   Table with error message if any, otherwise empty table.