User Tools

Site Tools


transformations:keepduplicates

Differences

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

Link to this comparison view

transformations:keepduplicates [2016/06/12 15:19] (current)
dmitry created
Line 1: Line 1:
 +===== Keep duplicates =====
  
 +This transformation keeps all duplicate rows and removes all unique rows. This operation can be performed on all columns, or only on specific columns. In the latter case uniqueness of values in not 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 ​ |
 +| Yangtze |  6300  | Eurasia |
 +| Yellow River (Huang He) |  5464  | Eurasia |
 +
 +**Objective:​** Find duplicates on column [Continent].
 +
 +**Output table:**
 +
 +^  River  ^  Length (km)  ^  Continent ​ ^
 +| Yangtze |  6300  | Eurasia|
 +| Yellow River (Huang He) |  5464  | Eurasia|
transformations/keepduplicates.txt · Last modified: 2016/06/12 15:19 by dmitry