Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision |
transformations:deduplicate [2021/04/25 12:22] – [DEDUPLICATE ROWS] craigt | transformations:deduplicate [2021/07/19 02:15] (current) – [Examples] craigt |
---|
\\ | \\ |
=====Examples===== | =====Examples===== |
**Objective:** Find and remove duplicate rows.\\ | **Example:** Find and remove duplicate rows.\\ |
| |
**Source table:** The longest rivers in the world | **Source table:** The longest rivers in the world |
| |
\\ | \\ |
**Result:** | **Result table:** |
^River ^Length (km) ^Continent ^ | ^River ^Length (km) ^Continent ^ |
| Nile | 6650| Africa | | | Nile | 6650| Africa | |
| Amazon | 6400| South America | | | Amazon | 6400| South America | |
| |
| \\ |
| ====Community examples==== |
| * [[https://community.easymorph.com/t//1269/1|Example: use of Web Request and Iterate Web Request with the Community forum API]] ([[https://community.easymorph.com/uploads/short-url/bGsC1xZtCgMa3rBWiPELwBTZLgX.morph|Project]]; Module: //Main//; Group: //Tab 1//;\\ Table: //Recently active users//; Action position: //9//) |
| * [[https://community.easymorph.com/t//1625/4|Create a new table with columns based on row values]] ([[https://community.easymorph.com/uploads/short-url/4oGLUNDHrUfB971H80ciuOAtOTG.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//) |
| * [[https://community.easymorph.com/t//1865/4|Dynamical genereting of path based on previous step]] ([[https://community.easymorph.com/uploads/short-url/70xVAnShgK4EiXuSa4HgMJtFAM2.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Calculate folder paths//;\\ Action position: //4//) |
| * [[https://community.easymorph.com/t//2156/1|How to process parent-child data structures]] ([[https://community.easymorph.com/uploads/short-url/zmylfn4Qr0ovzu3e5rybl0LVMNG.morph|Project]]; Module: //Module 1//; Group: //Tab 1//; Table: //Longest folder path//; Action position: //2//) |
| |
\\ | \\ |
=====See also===== | =====See also===== |
* [[transformations:keepduplicates|Keep duplicates]] | * [[transformations:keepduplicates|Keep duplicates]] |