transformations:keepexisting
This is an old revision of the document!
Keep Existing
This transformation only keeps rows where values in the specified column exist in the specified column of another table.
EXAMPLE
Table 1: Average income and deductions
Country | Gross income | Disposable income | Compulsory deductions |
---|---|---|---|
United States | 56067 | 45582 | 18.7% |
Ireland | 51218 | 48073 | 6.14% |
Luxembourg | 55176 | 47716 | 13.52% |
Australia | 51050 | 42617 | 16.52% |
Switzerland | 53716 | 48414 | 9.87% |
Canada | 45896 | 37469 | 18.36% |
Table 2: Average income and deductions - European Countries
Country |
---|
Ireland |
Luxembourg |
Switzerland |
Objective: Keep the rows of the first table that also exist in the second table
Transformation parameters:
- Column of the first table: Country
- Matching values in table: Table 2
- Column of the second table: Country
Result:
Country | Gross income | Disposable income | Compulsory deductions |
---|---|---|---|
Ireland | 51218 | 48073 | 6.14% |
Luxembourg | 55176 | 47716 | 13.52% |
Switzerland | 53716 | 48414 | 9.87% |
See also
transformations/keepexisting.1429322853.txt.gz · Last modified: 2015/04/17 22:07 by elenap