Combine Columns by Header

Source

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)

Input Ports

  1. Type: Data Arbitrary input data.

Output Ports

  1. Type: Data Input data + additional column containing string combination

Find here

Community Nodes > HCS Tools > Data Manipulation > Column > Split & Combine

Make sure to have this extension installed: