Split Columns by Header

This node uses a user-specified delimiter character to split the content of a selected column into parts similarly as the “Split Columns” node, with the extension that the column names of the new columns will be derived from the column header of the splitted column. This node works well together with the “Combine Columns by Header” node.

Example:
Plate Row Column
Plate01 A 1
Plate02 A 2
Combined by “::”
Plate::Row::Column
Plate01::A::1
Plate02::A::2

This Splitter node does the reverse with automatically naming the columns as above (instead of “Plate::Row::Column_Arr[0]”,….)

Options

Column selection
Select the column whose values are split.
Delimiter
Specify the delimiter in the value, that splits each part.
Quotation character
Specify the quotation character, if the different parts in the value are quoted. (The character to escape quotes is always the backslash.) If no quotation character is needed leave it empty.
Set Array Size
Check this and specify the number of columns to append. All created columns will be of type String. (See above for what happens if the split produces a different number of parts.)
Guess Size and Column Types
If this is checked, the node performs an additional scan through the entire data table and computes the number of columns needed to hold all parts of the split. In addition it determines the column type of the new columns.
Missing Value Handling
If select, the node creates empty string cell instead of missing value cells.

Input Ports

Icon
Input data table with column containing the cells to split

Output Ports

Icon
Output data table with additional columns.

Popular Predecessors

  • File Reader9 %
  • Cell Splitter7 %
  • Split Columns by Header6 %
  • Column Rename4 %
  • Combine Columns by Header4 %
  • CSV Reader4 %
  • Excel Reader (XLS)4 %
  • Range Splitter4 %
  • CSV Reader4 %
  • Column Filter3 %
  • GroupBy3 %
  • Row Filter3 %
  • Value Counter3 %
  • Rule Engine3 %
  • Value Filter3 %
  • Echo 550 Report Reader1 %
  • Loop End (Column Append)1 %
  • Scorer1 %
  • Concatenate1 %
  • Column Splitter1 %
  • String Replacer1 %
  • Conditional Label Assigner1 %
  • Distance Matrix Calculate1 %
  • Python Script (1⇒1)1 %
  • Smiles Reader1 %
  • Load Layout1 %
  • Number Formatter1 %
  • Number To String1 %
  • One to Many1 %
  • Reference Column Splitter1 %
  • Pivoting1 %
  • String Manipulation1 %
  • Java Snippet Row Splitter1 %
  • String to Term1 %
  • Column To XML1 %
  • XPath1 %
  • Column Filter (PMML)1 %
  • Excel Reader1 %

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.

Installation

To use this node in KNIME, install the extension KNIME HCS Tools from the below update site following our NodePit Product and Node Installation Guide:

v5.12
Plugin provider: Max Planck Institute of Molecular Cell Biology and Genetics (MPI-CBG)
Plugin version: 5.5.0.v202511111303
On NodePit since: 2026-07-06
Last update: 2026-07-18
KNIME versions: v5.12, v5.11, v5.10, v5.9, v5.8, v5.7, v5.6, v5.5, v5.4, v5.3, v5.2, v5.1, v4.7, v4.6, v4.5, v4.4, v4.3, v4.2, v4.1, v4.0, v3.7, v3.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!