transformations:deduplicate
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:deduplicate [2015/04/10 11:50] – elenap | transformations:deduplicate [2021/04/25 12:22] – [DEDUPLICATE ROWS] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Deduplicate | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Filters\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | EXAMPLE | + | \\ |
+ | =====Use cases===== | ||
+ | Use // | ||
- | **Source table:** The longest rivers | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Apply to|Select whether to base deduplication on all columns | ||
- | ^ River ^ Length (km) ^ Continent | + | \\ |
- | | Nile | 6650 | Africa | + | =====Remarks===== |
- | | Amazon | + | When deduplicating based on specific columns: |
- | | Nile | 6650 | Africa | + | |
+ | | ||
- | **Objective: | ||
- | **Output table:** | + | \\ |
+ | =====Examples===== | ||
+ | **Objective:** Find and remove duplicate rows.\\ | ||
- | ^ River ^ Length (km) ^ Continent | + | **Source table:** The longest rivers in the world |
- | | Nile | 6650 | Africa | + | ^ River ^ Length (km) ^ Continent |
- | | Amazon | + | | Nile | 6650| Africa |
+ | | Amazon | ||
+ | | Nile | 6650| Africa | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Apply to "All columns" | ||
+ | \\ | ||
+ | **Result:** | ||
+ | ^River | ||
+ | | Nile | 6650| Africa | ||
+ | | Amazon | ||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: |
transformations/deduplicate.txt · Last modified: 2021/07/19 02:15 by craigt