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 |