Differences

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

--- transformations:deduplicate [2014/10/25 17:14] – created dmitry
+++ transformations:deduplicate [2016/06/12 11:12] – dmitry
@@ Line 1: / Line 1: @@
 ===== Deduplicate =====
-This transformation removes all duplicating rows in entire table. It doesn't have parameters.
+This transformation removes all duplicate rows in entire table. Deduplication can be performed on all columns, or only on specific columns. In the latter case uniqueness of values in non-selected columns will be ignored.
+EXAMPLE
+**Source table:** The longest rivers in the world
+^  River  ^  Length (km)  ^  Continent  ^
+| Nile  |  6650  |  Africa  |
+| Amazon  |  6400  |  South America  |
+| Nile  |  6650  |  Africa  |
+**Objective:** Find and remove duplicate rows.
+**Output table:**
+^  River  ^  Length (km)  ^  Continent  ^
+| Nile  |  6650  |  Africa  |
+| Amazon  |  6400  |  South America  |