User Tools

Site Tools


transformations:keepduplicates

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