Iteration Collector

Options

Auto type cast columns: Select if an attempt to auto type cast the columns should take place
Columns on which to build indexes: Select the columns that are likely to be used in WHERE clauses by subsequent SQL calls. An index will be created on each column. Note that in this current implementation, each index is for a single column only, so compound (multi-column) indexes are not created.
Columns to be used in KNIME table: Select the columns to be used in the KNIME table. Only columns that are compatible with H2 database tables may be used
Table Name: Specify a table name to be used for this table in SQL. Table names will be case sensitive, and in SQL queries should be wrapped with double-quotes to ensure the correct case
Loop iteration counter variable: Enter the name of the variable that acts as the loop counter. This is normally currentIteration. When this variable is zero, it is considered to be the first iteration of the loop, and the collection table is initialised