Differences

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

--- transformations:keepexisting [2015/06/24 02:10] – dmitry
+++ transformations:keepexisting [2026/09/23 15:50] (current) – removed roberto
@@ Line 1: / Line 1: @@
-===== Keep Matching =====
-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:** Some European Countries
-^  Country  ^
-| Ireland  |
-| Luxembourg  |
-| Switzerland  |
-**Objective:** Keep only the European countries in the first 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]]