Iteration Collector

Used within a loop, this creates/appends to a SQL table for the supplied KNIME data table fro the current and previous loop iterations.

This allows the a DB Query to be placed outside of the loop, but connected to the same H2 database and so the currently collected data can be inspected. This is intended primarily for debugging/progress information rather than for use beyond the loop itself.


KNOWN LIMITATIONS
Column names must be compatible with an H2 SQL database. Where the column name contains spaces, this will be handled by converted to underscores for processing in the database. Column names must consist of Alphanumerics and underscores, and must not start with a numeric. Column names containing other characters will most likely fail.


v1.0 2024-09-12 @takbb Brian Bates

Input ports

1. Type: DB Session
   Database Connection
   Database connection. Typically it is intended that an H2 database be used for local data manipulation, as this will work with the index creation scripts. Other db connections may not be compatible with the internal scripts used by this component.
2. Type: Table
   Data Table
   Table containing data to be included in the database table

Output ports

1. Type: Table
   Database table data throughport
   The input table as it appears on the database. The column names on this table represent any changes to column names to make them compliant with SQL column names. Use this as the reference for column names when writing the SQL
2. Type: DB Data
   Database Data
   A database data port onto the idatabase allowing in-database nodes to be connected
3. Type: DB Session
   DB Session
   DB Session through-port for connecting to other table connectors