Icon

Concatenate

The Concatenate node is used to combine vertically (union) two or more tables. Tables are combined according to their column names. Only names that match exactly are stacked atop one another.

There are two options for which columns to show:

- Use union of columns: All columns from all concatenated tables will appear in the results. Records from columns that are not present in any one table will be given null (?) values.

- Use intersection of columns: Only columns that are present in all concatenated tables will appear in the results.


By default, only two input tables are available. You may add more ports by pressing the ellipses (three dots) button in the lower-left corner of the node icon. You may add as many ports as you desire.

Concatenate The Concatenate node is used to combine vertically (union) two or more tables. Tablesare combined according to their column names. Only names that match exactly arestacked atop one another. There are two options for which columns to show:- Use union of columns: All columns from all concatenated tables will appear in theresults. Records from columns that are not present in any one table will be given null (?) values.- Use intersection of columns: Only columns that are present in all concatenated tableswill appear in the results.By default, only two input tables are available. You may add more ports by pressing theellipses (three dots) button in the lower-left corner of the node icon. You may add asmany ports as you desire. Concatenate two tables with an intersection of theircolumns. Notice that only the columns common toeach table are in the results. Night Heron Data, 2023 The union of columns can result in some recordshaving null (?) values if a column is not present in allconcatenated tables. Add additional ports to concatenate four tables. Sincewe changed some field names in one of the inputtables, those columns are not matched and are thusset to the side. Input some dataTwo tables,intersection ofcolumnsRemoved latitudeand longitude fieldsRemoved populationand date fieldsRenamed StateNameand StateCode fieldsTwo tables,union ofcolumnsMultiple tables,union of columns Table Creator Concatenate Table Creator Table Creator Table Creator Concatenate Concatenate Concatenate The Concatenate node is used to combine vertically (union) two or more tables. Tablesare combined according to their column names. Only names that match exactly arestacked atop one another. There are two options for which columns to show:- Use union of columns: All columns from all concatenated tables will appear in theresults. Records from columns that are not present in any one table will be given null (?) values.- Use intersection of columns: Only columns that are present in all concatenated tableswill appear in the results.By default, only two input tables are available. You may add more ports by pressing theellipses (three dots) button in the lower-left corner of the node icon. You may add asmany ports as you desire. Concatenate two tables with an intersection of theircolumns. Notice that only the columns common toeach table are in the results. Night Heron Data, 2023 The union of columns can result in some recordshaving null (?) values if a column is not present in allconcatenated tables. Add additional ports to concatenate four tables. Sincewe changed some field names in one of the inputtables, those columns are not matched and are thusset to the side. Input some dataTwo tables,intersection ofcolumnsRemoved latitudeand longitude fieldsRemoved populationand date fieldsRenamed StateNameand StateCode fieldsTwo tables,union ofcolumnsMultiple tables,union of columns Table Creator Concatenate Table Creator Table Creator Table Creator Concatenate Concatenate

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-19
On NodePit since: 2023-05-21
Last update: 2024-05-02
Created with KNIME version: v4.7.2
Tags: concatenatenode bitesnight heron data

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

Try NodePit Runner!