User Tools

Site Tools


transformations:keepexisting

Keep Matching

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.txt · Last modified: 2015/06/23 22:10 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki