User Tools

Site Tools


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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki