Remove duplicate rows from a data table
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Table Variable tableName | variable | Required | — | — |
Columns to Compare compareColumns | array | Optional | — | Compare only these columns (leave empty for all columns) |
Keep First Occurrence keepFirst | boolean | Optional | true | — |
Output Variable outputVariable | variable | Optional | uniqueTable | — |
Output
uniqueTableDataTableTable with duplicate rows removed
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Add table column
Add a new column to an existing data table
Add table row
Add a new row to a table
Clear table
Remove all rows from a data table
Convert table to text
Turn table data into a text format like CSV
Create table
Create a new table to store rows and columns of data
Filter table
Keep only rows that match certain conditions