transformations:keepexisting
Differences
This shows you the differences between two versions of the page.
Next revisionBoth sides next revision | |||
transformations:keepexisting [2014/10/25 17:16] – created dmitry | transformations:keepexisting [2015/04/10 12:58] – elenap | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Keep Existing ===== | ===== Keep Existing ===== | ||
- | This transformation | + | This transformation only keeps rows where values in the specified column exist in the specified column of another table. |
+ | EXAMPLE | ||
+ | |||
+ | **Source table 1:** Average income and deductions | ||
+ | |||
+ | ^ Country | ||
+ | | United States | ||
+ | | Ireland | ||
+ | | Luxembourg | ||
+ | | Australia | ||
+ | | Switzerland | ||
+ | | Canada | ||
+ | |||
+ | **Source table 2:** Average income and deductions - European Countries | ||
+ | |||
+ | ^ Country | ||
+ | | Ireland | ||
+ | | Luxembourg | ||
+ | | Switzerland | ||
+ | |||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **Transformation parameters: | ||
+ | |||
+ | * Column of the first table: Country | ||
+ | * Matching values in table: Table 2 | ||
+ | * Column of the second table: Country | ||
+ | |||
+ | **Output table:** | ||
+ | |||
+ | ^ Country | ||
+ | | Ireland | ||
+ | | Luxembourg | ||
+ | | Switzerland | ||
+ | |||
+ | |||
+ | === See also === | ||
+ | * [[transformations: |
transformations/keepexisting.txt · Last modified: 2015/06/23 22:10 by dmitry