transformations:keepduplicates
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionNext revision | |||
— | transformations:keepduplicates [2021/04/26 00:50] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ====== KEEP DUPLICATES====== | ||
+ | Category: Transform / Filters\\ | ||
+ | \\ | ||
+ | =====Description===== | ||
+ | This action 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, the uniqueness of values in columns not selected will be ignored.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | In datasets where all records should be unique, this action helps clean them by looking for duplicate values/ | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Apply to|Select whether to check the values in all columns for duplicates, or just specified columns. | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Objective: | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | ^River | ||
+ | | Nile | 6650| Africa | ||
+ | | Amazon | ||
+ | | Yangtze | 6300| Eurasia | ||
+ | | Yellow River (Huang He) | 5464| Eurasia | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Apply to " | ||
+ | > Columns: | ||
+ | |||
+ | \\ | ||
+ | **Result:** | ||
+ | ^River | ||
+ | | Yangtze | ||
+ | | Yellow River (Huang He) | 5464| Eurasia | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/keepduplicates.txt · Last modified: 2021/07/19 02:13 by craigt