XLS Control Table Generator

The XLS Control Table Generator node takes an input data table and transforms it to an XLS Control Table, meaning it exchanges the column names to A, B, C, ... and the row IDs to 1, 2, 3, ... just like they would appear when opening the xlsx file in a spreadsheet application.

Optionally you can unpivot the table as well to make use of Rule Engine nodes later for flexible and dynamic XLS formatting workflows. A second operation type allows to pivot this special table layout back to the final desired XLS Control Table structure.

Options

Operation Type (automatically set based on the provided input table)

from arbitrary input table to XLS Control Table (wide or long/unpivoted)

If no special input table is detected, this mode of operation will exchange the input table's column and row headers to XLS-like style.

from long/unpivoted layout to wide XLS Control Table

If the output of a previous unpivot operation by this node (see below) is detected as input table specification (no additional columns are allowed in this case), this mode pivots them back to a valid (wide) XLS Control Table.
In case you expected your input table to be of this kind, but the standard operation type was detected, please activate the debug logging view to learn about the cause of this decision.

Shift Rows Option

use first row as column header

Copy the original table's column header to a new first row. This is typically used in line with the corresponding setting in KNIME's Excel Writer node.

Result Table Structure Options

unpivot result table (for easier post-processing and re-pivoting)

Unpivot your input table, meaning that each input table cell will become an own output table row. On this basis, own rules can be defined, e.g. to define tags required for many of the XLS Formatting nodes.

add more header columns

Add column headers like the column number, original column names, original row ID, and padded XLS column name. Padding is useful as wide tables might otherwise be difficult to correctly sort (e.g. AA, Y, Z order instead of Y, Z, AA -> solved via 00Y, 00Z, 0AA).

Contradiction Resolution Strategy at Operation Type 'long to wide'

fail

If two or more columns hold contradicting target cell addressing information, let this node fail with an exception.

use 'Cell'

If two or more columns hold contradicting target cell addressing information, ignore all columns but 'Cell'.

use 'Column' and 'Row'

If two or more columns hold contradicting target cell addressing information, ignore all columns but 'Column' and 'Row'.

use 'Column (comparable)' and 'Row'

If two or more columns hold contradicting target cell addressing information, ignore all columns but 'Column (comparable)' and 'Row'.

use 'Column (number)' and 'Row'

If two or more columns hold contradicting target cell addressing information, ignore all columns but 'Column (number)' and 'Row'.

Views

This node has no views

Workflows

• 01_Correlation_MatrixKNIME Hub
• 01_XLS_ControlTablesKNIME Hub
• 01_XLS_ControlTablesKNIME Hub
• 02 - create control table for taggingKNIME Hub
• 02_Pretty_TableKNIME Hub
• Show all 169 workflows

Links

• No links available

Developers