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: Some European Countries
Country |
---|
Ireland |
Luxembourg |
Switzerland |
Objective: Keep only the European countries in the first 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.1429880309.txt.gz · Last modified: 2015/04/24 08:58 by dmitry