Icon

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.

Column Combiner The Column Combiner node combines (concatenates) the values in two or morecolumns into a single string.Please note that the strings are created in the order in which the columns appear in theinput table. That is, if Field1 = "World" and Field2 = "Hello" the combined column stringwould read "World","Hello".Several options are available for constructing the combined string. You can choose thedelimiter (a comma by default), if each value should be quoted, how to handle if thechosen delimiter appears in the original string, the name of the new field, and if thecombined columns should be removed.Finally, you can select columns manually, by wildcard or regular expression, or by theirtypes just as in the Column Filter node. Combine the Country and StateName strings with acomma delimiter. Do not place quotes around eachcomponent, and do not remove the original columns. Night Heron Data, 2023 Here, we combined all fields (notice we checked"Enforce Exclusion" so that even new fields will beincluded). We used the pipe as a delimiter andquoted each string. This node can be helpful increating a data structure like this when it isnecessary, Input some dataCombine string,keep originalsCombine allfields into onestring Table Creator Column Combiner Column Combiner Column Combiner The Column Combiner node combines (concatenates) the values in two or morecolumns into a single string.Please note that the strings are created in the order in which the columns appear in theinput table. That is, if Field1 = "World" and Field2 = "Hello" the combined column stringwould read "World","Hello".Several options are available for constructing the combined string. You can choose thedelimiter (a comma by default), if each value should be quoted, how to handle if thechosen delimiter appears in the original string, the name of the new field, and if thecombined columns should be removed.Finally, you can select columns manually, by wildcard or regular expression, or by theirtypes just as in the Column Filter node. Combine the Country and StateName strings with acomma delimiter. Do not place quotes around eachcomponent, and do not remove the original columns. Night Heron Data, 2023 Here, we combined all fields (notice we checked"Enforce Exclusion" so that even new fields will beincluded). We used the pipe as a delimiter andquoted each string. This node can be helpful increating a data structure like this when it isnecessary, Input some dataCombine string,keep originalsCombine allfields into onestring Table Creator Column Combiner Column Combiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: johnemery
Created at: 2023-05-26
On NodePit since: 2023-05-26
Last update: 2024-11-21
Created with KNIME version: v4.7.2
Tags: column combinernode bitesnight heron dataconcatenate columns

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

Try NodePit Runner!