Differences

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

--- transformations:remove [2014/10/25 18:30] – created dmitry
+++ transformations:remove [2015/04/10 15:04] – elenap
@@ Line 1: / Line 1: @@
 ===== Remove columns =====
-This transformation removes selected columns.
+This transformation removes selected columns. Several columns can be removed in one transformation.
+EXAMPLE
+**Source table:** The longest rivers in the world
+^  River  ^  Length (km)  ^  Length (miles)  ^  Continent  ^
+| Nile  |  6650  |  4132  |  Africa  |
+| Amazon  |  6400  |  3976  |  South America  |
+| Yangtze  |  6300  |  3917  |  Asia  |
+| Mississippi  |  6275  |  3902  |  North America  |
+**Objective:** Remove the column describing the length of the river in miles.
+**Transformation parameters:**
+  * Columns to remove: Length (miles)
+**Output table:**
+^  River  ^  Length (km)  ^  Continent  ^
+| Nile  |  6650  |  Africa  |
+| Amazon  |  6400  |  South America  |
+| Yangtze  |  6300  |  Asia  |
+| Mississippi  |  6275  |  North America  |