Differences

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

--- transformations:keepdifferent [2015/04/10 20:01] – 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 the specified column are missing in the specified column of another table.
@@ Line 5: / Line 5: @@
 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  ^
+^Country ^
-| Ireland  |
+|Ireland |
-| Luxembourg  |
+|Luxembourg |
-| Switzerland  |
+|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  ^