EasyMorph Help

User Tools

Site Tools

You are here: start » transformations » keepexisting
transformations:keepexisting

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
transformations:keepexisting [2015/04/10 20:02] – elenaptransformations:keepexisting [2015/06/23 22:10] (current) – dmitry
Line 1: Line 1:
-===== Keep Existing =====+===== Keep Matching =====
  
 This transformation only keeps rows where values in the specified column exist in the specified column of another table. This transformation only keeps rows where values in the specified column exist in the specified column of another table.
Line 5: Line 5:
 EXAMPLE EXAMPLE
  
-**Source table 1:** Average income and deductions+**Table 1:** Average income and deductions
  
 ^  Country  ^  Gross income   ^  Disposable income  ^  Compulsory deductions  ^ ^  Country  ^  Gross income   ^  Disposable income  ^  Compulsory deductions  ^
Line 15: Line 15:
 | Canada  |  45896  |  37469  |  18.36%  | | Canada  |  45896  |  37469  |  18.36%  |
  
-**Source table 2:** Average income and deductions - European Countries+**Table 2:** Some European Countries
  
 ^  Country  ^ ^  Country  ^
Line 23: Line 23:
  
  
-**Objective:** Keep the rows of the first table that also exist in the second table+**Objective:** Keep only the European countries in the first table.
  
 **Transformation parameters:** **Transformation parameters:**
Line 31: Line 31:
   * Column of the second table: Country   * Column of the second table: Country
  
-**Output table:**+**Result:**
  
 ^  Country  ^  Gross income   ^  Disposable income  ^  Compulsory deductions  ^ ^  Country  ^  Gross income   ^  Disposable income  ^  Compulsory deductions  ^
transformations/keepexisting.txt · Last modified: 2015/06/23 22:10 by dmitry
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki