Stack Table Columns as Rows

0 ×

Options

Return Orignal Row ID

Select if you want to return the original RowID from which the "stacked" data has been returned. If selected, this will return a new column "OrigRowId"

Return Original Column Name column

Select this option to return the original column name into the OriginalColumnName column. This will assist with identifying the origin of the value being stacked

Columns to be Stacked

Choose the set of columns to be stacked.

Row Chunk Size

Number of rows to be processed in a single chunk. This is to reduce memory overhead during pivoting and unpivoting. Set to a high number (higher than table row count) if operation is to be performed in a single chunk

Rule Engine $ColumnName$ change rules

Enter a script that is compatible with Rule Engine that defines the column renaming.%%00010Note that column renaming only applies to the Columns that have been chosen to be "stacked". It will have no effect on the other columns.%%00010%%00010Use $ColumnName$ as the column name identifier%%00010e.g.%%00010$ColumnName$ LIKE "Customer*" => "Customer"%%00010$ColumnName$ LIKE "OrderDate*" => "OrderDate"%%00010$ColumnName$ LIKE "Product*" => "Product"%%00010%%00010Be sure not to leave any BLANK lines on the end of the rules!

Original Column Name String Search

Enter a regex pattern to find in the Original Column Name

Original Column Name String Replacement

Enter a regex replacement string to use based on the Original Column Name

Return Original Column Name as

Enter the name to be given to the column that will contain "Original Column Name"

Nodes

• String Configuration12 ×
• Column Filter10 ×
• Component Input8 ×
• Component Output8 ×
• NoOp (Table)8 ×
• Show all 54 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Quick Forms
• FeatureNodePit Power Nodes

Links

• No links available