Differences

This shows you the differences between two versions of the page.

--- transformations:keepduplicates [2016/06/12 11:19] – created dmitry
+++ transformations:keepduplicates [2025/01/21 18:13] (current) – revise to 2025 format craigt
@@ Line 1: / Line 1: @@
-===== Keep duplicates =====
+{{ transformations:KeepDuplicatesAction.png}}
+====== KEEP DUPLICATES======
+Category: Transform / Filters\\
-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.
+\\
+=====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.\\
-EXAMPLE
+\\
+=====Use cases=====
+In datasets where all records should be unique, this action helps clean them by looking for duplicate values/records and pulling them out for review - to determine if those records warrant removal or modification.\\
-**Source table:** The longest rivers in the world
+\\
+=====Action settings=====
+^Setting ^Description ^
+|Apply to|Select whether to check the values in all columns for duplicates, or just specified columns.  Options:  //All columns// or\\ //Selected columns// (and select the columns to check).|
-^  River  ^  Length (km)  ^  Continent  ^
+\\
-| Nile  |  6650  | Africa  |
+=====Examples=====
-| Amazon  |  6400  | South America  |
-| Yangtze |  6300  | Eurasia |
-| Yellow River (Huang He) |  5464  | Eurasia |
-**Objective:** Find duplicates on column [Continent].
+====Example #1====
+>Find duplicates in column "Continent".\\
-**Output table:**
+===Before (source table)===
+^River  ^Length (km)  ^Continent  ^
+| Nile  |  6650| Africa  |
+| Amazon  |  6400| South America  |
+| Yangtze |  6300| Eurasia  |
+| Yellow River  |  5464| Eurasia  |
-^  River  ^  Length (km)  ^  Continent  ^
+===After (result table)===
-| Yangtze |  6300  | Eurasia|
+^River  ^Length (km)  ^Continent  ^
-| Yellow River (Huang He) |  5464  | Eurasia|
+|**Yangtze**  |  **6300**|**Eurasia**  |
+|**Yellow River**  |  **5464**|**Eurasia**  |
+===Action parameters===
+> Apply to: Selected columns
+> Selected columns: Continent
+\\
+=====Community examples=====
+  * [[https://community.easymorph.com/t//675/5|Compare two Excel sheets with EasyMorph]] ([[https://community.easymorph.com/uploads/short-url/xQLWtAogCqcMrglyfXLKmrAF7aR.morph|Project]]; Module: //Main//; Group: //Compare data//; Table: //Matching rows//; Action position: //3//)
+\\
+=====See also=====
+  * [[transformations:deduplicate|Deduplicate rows]]
+  * [[transformations:filterminmax|Keep min/max]]
+  * [[transformations:keepremovematching|Keep/Remove matching]]