transformations:keepduplicates
This is an old revision of the document!
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.1465744765.txt.gz · Last modified: 2016/06/12 11:19 by dmitry