transformations:keepduplicates
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:keepduplicates [2016/06/12 11:19] – created dmitry | transformations:keepduplicates [2021/07/19 02:13] (current) – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Keep duplicates | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Filters\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | EXAMPLE | + | \\ |
+ | =====Use cases===== | ||
+ | In datasets where all records should be unique, this action helps clean them by looking for duplicate values/ | ||
- | **Source table:** The longest rivers | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Apply to|Select whether to check the values | ||
- | ^ River ^ Length (km) ^ Continent | ||
- | | Nile | 6650 | Africa | ||
- | | Amazon | ||
- | | Yangtze | 6300 | Eurasia | | ||
- | | Yellow River (Huang He) | 5464 | Eurasia | | ||
- | **Objective:** Find duplicates | + | \\ |
+ | =====Examples===== | ||
+ | **Example:** Find duplicates | ||
+ | |||
+ | **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 table:** | ||
+ | ^River | ||
+ | | Yangtze | ||
+ | | Yellow River (Huang He) | 5464| Eurasia | ||
- | **Output table:** | + | \\ |
+ | ====Community examples==== | ||
+ | | ||
- | ^ River ^ Length (km) ^ Continent | + | \\ |
- | | Yangtze | 6300 | + | =====See also===== |
- | | Yellow River (Huang He) | 5464 | Eurasia| | + | * [[transformations: |
+ | | ||
+ | |
transformations/keepduplicates.1465744765.txt.gz · Last modified: 2016/06/12 11:19 by dmitry