Differences

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

--- transformations:keepdifferent [2015/04/10 12:52] – elenap
+++ transformations:keepdifferent [2015/06/23 22:10] (current) – dmitry
@@ Line 1: / Line 1: @@
-===== Keep Different =====
+===== Keep Mismatching =====
-This transformation only keeps rows where values in specified column are missing in specified column of another table.
+This transformation only keeps rows where values in the specified column are missing in the specified column of another table.
 EXAMPLE
-**Source table 1:** Average income and deductions
+**Table 1:** Average income and deductions
 ^  Country  ^  Gross income   ^  Disposable income  ^  Compulsory deductions  ^
@@ Line 15: / Line 15: @@
 | Canada  |  45896  |  37469  |  18.36%  |
-**Source table 2:** Average income and deductions - European Countries
+**Table 2:** Some European countries
-^  Country  ^  Gross income   ^  Disposable income  ^  Compulsory deductions  ^
+^Country ^
-| Ireland  |  51218  |  48073  |  6.14%  |
+|Ireland |
-| Luxembourg  |  55176  |  47716  |  13.52%  |
+|Luxembourg |
-| Switzerland  |  53716  |  48414  |  9.87%  |
+|Switzerland |
-**Objective:** Keep the rows of the first table that are missing in the second table
+**Objective:** Remove the European countries from the first table.
 **Transformation parameters:**
@@ Line 31: / Line 31: @@
   * Column of the second table: Country
-**Output table:**
+**Result:**
 ^  Country  ^  Gross income   ^  Disposable income  ^  Compulsory deductions  ^