Append
Stack tables with similar columns on top of each other
Append allows for the union of two or more datasets of similar shapes.
Input/Output
Input | Output |
Table[s] to append - any table | Up to 64 tables may be linked to Append. Tables are appended in the order in which they are linked, with the first table appearing at the top. |
Options
Option | Description |
Append based on position | If switched on, Append ignores column names and appends columns based on their position in the table. |
The Append tool will not automatically update while in the tool view. When you are finished connecting nodes to the tool, click to open it and then click the 'Update' button in the bottom right corner to run. If you add or remove any connections to the Append tool, remember to re-run by clicking that 'Update' button for the changes to be reflected in the preview.
Tip: use the Validate Schema tool to check table alignment before appending tables together
Last updated