User Tools

Site Tools


transformations:append

This is an old revision of the document!


Append table

Appends another table. The action can operate in 2 modes:

Appends rows - the other table (dataset) is appended as new rows at the bottom of current table. Columns with the same name in both tables appear as one column in the result table. Columns on 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. Columns from the appended table with the same name as in the main table are automatically renamed. The length of the resulting table has the length of the longest of the two table.

EXAMPLE

Table 1: The longest rivers in the world

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

Table 2: The outflow

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

Objective: Append Table 2 to Table 1

Result:

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

More examples

See also

transformations/append.1607086805.txt.gz · Last modified: 2020/12/04 08:00 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki