Column Combiner

The Column Combiner node combines (concatenates) the values in two or more columns into a single string.

Please note that the strings are created in the order in which the columns appear in the input table. That is, if Field1 = "World" and Field2 = "Hello" the combined column string would read "World","Hello".

Several options are available for constructing the combined string. You can choose the delimiter (a comma by default), if each value should be quoted, how to handle if the chosen delimiter appears in the original string, the name of the new field, and if the combined columns should be removed.

Finally, you can select columns manually, by wildcard or regular expression, or by their types just as in the Column Filter node.