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.