transformations:keepduplicates
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
| Next revision | |||
| — | transformations:keepduplicates [2016/06/12 11:19] – created dmitry | ||
|---|---|---|---|
| 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: 2021/07/19 02:13 by craigt