Unique Tool

Use the Unique tool to separate unique and duplicate data, based on the columns you select.

Configure the tool

Column names: Select the column or columns to find unique values from. Use Select all to compare all. The data is sorted based on the Unique columns. Therefore if there is a specific sort order desired, use the Sort Tool to assign the specific sort order of the file prior to using the Unique tool. Select Deselect all to deselect all columns.

Output anchors

The Unique tool has two output anchors:

U anchor: The first row of each group.

D anchor: The remaining rows from each group.