Combine Columns by Header

IMPORTANT: This node will ignore the user-defined new column name and will use an auto-generated one. Combines the content of a set of columns and appends the concatenated string as separate column to the input table. The user needs to specify in the dialog the columns of interest and some other properties, such as delimiter to separate the different cell contents and quoting options. 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 Combine node automatically gives new column names (“Name of appended column” field will be ignored)

Options

Delimiter
Enter a delimiter string here. This string is used to separate the different cell contents in the new, appended column.
Quote Character
The character entered here will be used to quote the cell content in case that it contains the delimiter string (for instance if the cell content is some;value, the delimiter string is ';' (a single semicolon), and the quote character is '"' (single quote char) the quoted string will be "some;value" (including quotes)). You can force quotation by checking "Quote Always". Alternatively, the user can also replace the delimiter string in the cell content string (see below).
Replace Delimiter by
If the string representation of the cell content contains the delimiter string, it will be replaced by the string entered here (if you entered '-' here, the output of the above example would be some-value).
Name of appended column
Auto-generated new column name (editing this field will be ignored).
Column Selection
Move the columns of interest into the "Include" list.

Input Ports

Icon
Arbitrary input data.

Output Ports

Icon
Input data + additional column containing string combination

Popular Predecessors

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

A zipped version of the software site can be downloaded here.

Plugin provider: Max Planck Institute of Molecular Cell Biology and Genetics (MPI-CBG)
Plugin version: 5.3.0.v202407011120
On NodePit since: 2024-07-11
Last update: 2024-10-30
KNIME versions: 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!