transformations:keepduplicates
Differences
This shows you the differences between two versions of the page.
| — |
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 | ||
| + | | Yangtze | 6300 | Eurasia | | ||
| + | | Yellow River (Huang He) | 5464 | Eurasia | | ||
| + | |||
| + | **Objective: | ||
| + | |||
| + | **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
Page Tools
