User Tools

Site Tools


transformations:append

Append table

This transformation appends another table at the bottom of current table. Columns with the same name in both tables appear as one column in the result 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

See also

transformations/append.txt · Last modified: 2015/04/18 03:33 by elenap