transformations:append
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:append [2020/12/04 08:00] – dmitry | transformations:append [2021/04/07 14:16] – [Use cases] dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Append table ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Basic\\ | ||
- | Appends | + | \\ |
+ | =====Description===== | ||
+ | This action appends | ||
+ | \\ | ||
+ | ====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. | ||
- | **Appends rows** - the other table (dataset) is appended as new rows at the bottom | + | 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 | ||
- | This mode has the useful feature | + | \\ |
+ | =====Use cases (Append rows)===== | ||
+ | * Concatenation | ||
+ | * Incremental loading. | ||
- | **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. | ||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Table to append|Select the dataset to append to the current one.| | ||
+ | |Mode|Options: | ||
- | EXAMPLE | + | Regardless of the mode, a dotted line will connect this action to the appended dataset in the application window. |
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Objective: | ||
**Table 1:** The longest rivers in the world | **Table 1:** The longest rivers in the world | ||
- | ^ River ^ Length (km) ^ Continent | + | ^River |
- | | Nile | 6650 | Africa | + | | Nile | 6650|Africa |
- | | Amazon | + | | Amazon |
- | | Yangtze | + | | Yangtze |
- | | Mississippi | + | | Mississippi |
**Table 2:** The outflow | **Table 2:** The outflow | ||
- | ^ River ^ Outflow | + | ^River |
- | | Nile | Mediterranean | + | | Nile |Mediterranean |
- | | Amazon | + | | Amazon |
- | | Yangtze | + | | Yangtze |
- | | Mississippi | + | | Mississippi |
- | + | \\ | |
- | + | **Action parameters:** | |
- | **Objective:** Append | + | > |
+ | \\ | ||
**Result:** | **Result:** | ||
- | ^ River ^ Length (km) ^ Continent | + | ^River |
- | | Nile | 6650 | Africa | + | | Nile | 6650|Africa |
- | | Amazon | + | | Amazon |
- | | Yangtze | + | | Yangtze |
- | | Mississippi | + | | Mississippi |
- | | Nile | | | Mediterranean | + | | Nile | | |Mediterranean |
- | | Amazon | + | | Amazon |
- | | Yangtze | + | | Yangtze |
- | | Mississippi | + | | Mississippi |
- | === More examples === | + | \\ |
- | * [[https:// | + | =====More examples===== |
- | * [[https:// | + | * [[https:// |
- | * [[https:// | + | * [[https:// |
+ | ]] | ||
+ | * [[https:// | ||
- | === See also === | + | \\ |
+ | =====See also===== | ||
* [[transformations: | * [[transformations: | ||
* [[transformations: | * [[transformations: | ||
transformations/append.txt · Last modified: 2021/07/19 02:32 by craigt