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 [2015/04/19 11:39] – elenap | ||
|---|---|---|---|
| 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