transformations:merge
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:merge [2015/04/17 23:32] – elenap | transformations:merge [2017/01/01 15:32] – dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Blend in/ Merge table ===== | + | ===== Merge another |
This transformation appends one or more columns from another table where certain columns in both tables match. | This transformation appends one or more columns from another table where certain columns in both tables match. | ||
Line 8: | Line 8: | ||
* Left Join Mode -- get **all** matching combinations from the other table. It can increase number or rows in the current table. | * Left Join Mode -- get **all** matching combinations from the other table. It can increase number or rows in the current table. | ||
- | To make full outer join, first, append rows that exist in the other tables | + | To make full outer join, first, append rows that exist in the other table but are missing in the current table using [[transformations: |
EXAMPLE | EXAMPLE | ||
Line 35: | Line 35: | ||
* Add columns from table: Table 2 | * Add columns from table: Table 2 | ||
* Column: Outflow | * Column: Outflow | ||
- | * Merge mode: Add more rows to this table and all all matching rows from Table 2 (i.e. do left join) | + | * Merge mode: Add more rows to this table and all matching rows from Table 2 (i.e. do left join) |
**Result:** | **Result:** |
transformations/merge.txt · Last modified: 2024/04/11 23:55 by craigt