transformations:append
This is an old revision of the document!
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.1429328021.txt.gz · Last modified: 2015/04/17 23:33 by elenap