User Tools

Site Tools


transformations:keepexisting

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
transformations:keepexisting [2015/04/18 02:07]
elenap
transformations:keepexisting [2015/06/24 02:10]
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 15: Line 15:
 | Canada  |  45896  |  37469  |  18.36%  | | Canada  |  45896  |  37469  |  18.36%  |
  
-**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:**
transformations/keepexisting.txt · Last modified: 2015/06/24 02:10 by dmitry