Category: Transform / Filters

This action removes all duplicate rows in the entire table. Deduplication can be performed based on all columns, or only on specific columns.

Use Deduplicate rows to clean datasets of records that may have been duplicated in the source dataset, or during previous actions.

When deduplicating based on specific columns:

• The uniqueness of values in non-selected columns will be ignored.
• Duplicate rows are removed from the dataset from the bottom, up.

Example: Find and remove duplicate rows.

Source table: The longest rivers in the world

Action parameters:

Apply to "All columns"

Result table:

• Example: use of Web Request and Iterate Web Request with the Community forum API (Project; Module: Main; Group: Tab 1;
  Table: Recently active users; Action position: 9)
• Create a new table with columns based on row values (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 3)
• Dynamical genereting of path based on previous step (Project; Module: Main; Group: Tab 1; Table: Calculate folder paths;
  Action position: 4)
• How to process parent-child data structures (Project; Module: Module 1; Group: Tab 1; Table: Longest folder path; Action position: 2)

• Keep duplicates