User Tools

Site Tools


transformations:append

APPEND ANOTHER TABLE

Category: Transform / Basic


Description

This action appends another table to the current dataset. This action can operate in 2 modes:

Append rows

The other table (dataset) is appended as new rows at the bottom of the current table. Columns with the same name in both tables appear as one column in the result table. Columns in the appended table that don't exist in the main table are appended on the right.

This mode has the useful feature of preserving the order of columns of the main dataset to which the other dataset is appended.

Append columns

The other table (dataset) is appended as new columns to the right of the current dataset. Columns from the appended table with the same name as in the main table are automatically renamed. The length of the resulting table is the longest length of the two tables.


Use cases (Append rows)

  • Concatenation of similar datasets.
  • Incremental loading.

To append multiple datasets, apply the "Append" action multiple times.


Action settings

SettingDescription
Table to appendSelect the dataset to append to the current one.
ModeOptions: Append rows at the bottom (columns with the same name are concatenated into one column), and,
Append columns to the right (columns with the same names are automatically renamed)

Regardless of the mode, a dotted line will connect this action to the appended dataset in the application window.


Examples

Objective: Append Table 2 to Table 1 as additional columns.

Table 1: The longest rivers in the world

River Length (km) Continent
Nile 6650Africa
Amazon 6400South America
Yangtze 6300Asia
Mississippi 6275North America

Table 2: The outflow

River Outflow
Nile Mediterranean
Amazon Atlantic Ocean
Yangtze East China Sea
Mississippi Gulf of Mexico


Action parameters:

Append columns to the right


Result:

River Length (km) Continent Outflow
Nile 6650Africa
Amazon 6400South America
Yangtze 6300Asia
Mississippi 6275North America
Nile Mediterranean
Amazon Atlantic Ocean
Yangtze East China Sea
Mississippi Gulf of Mexico


More examples

See also

transformations/append.txt · Last modified: 2021/04/07 14:17 by dmitry