Remove duplicate rows from a data table
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Table Variable tableName | variable | Required | Not set | |
Columns to Compare compareColumns | array | Optional | Not set | 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
Convert to Table
Convert API response data to a table format for Excel
Create table
Create a new table to store rows and columns of data