Differences

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

--- transformations:keepexisting [2014/10/25 17:16] – created dmitry
+++ transformations:keepexisting [2015/04/17 22:07] – elenap
@@ Line 1: / Line 1: @@
 ===== Keep Existing =====
-This transformation leaves only rows where values in specified column exist in specified column of another table.
+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:** Average income and deductions - European Countries
+^  Country  ^
+| Ireland  |
+| Luxembourg  |
+| Switzerland  |
+**Objective:** Keep the rows of the first table that also exist in the second 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:keepdifferent|Keep Different]]