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'.

Input Ports

Icon
Data table, typically holding the raw data of your xlsx sheet. Alternatively, the output of a previous instance of this node (in 'unpivot' mode) with the purpose to be pivoted back to wide table layout.

Output Ports

Icon
The generated XLS Control Table (or its unpivoted version).

Popular Successors

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.