transformations:keepdifferent
This is an old revision of the document!
Keep Different
This transformation only keeps rows where values in the specified column are missing 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 are missing 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 |
---|---|---|---|
United States | 56067 | 45582 | 18.7% |
Australia | 51050 | 42617 | 16.52% |
Canada | 45896 | 37469 | 18.36% |
See also
transformations/keepdifferent.1429880131.txt.gz · Last modified: 2015/04/24 08:55 by dmitry