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 this action to remove records that may have been duplicated in the source dataset or during previous actions, and keep unique records only.

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.

Find and remove duplicate rows based on the values in all columns.

Apply to: All columns

Remove duplicate rows based on First and Last Names.

Apply to: Selected columns (FirstName, LastName)

• 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