Blue circle with white snowflake inside.

Unique Tool

Version:
Current
Last modified: May 06, 2020

Use the Unique tool to distinguish whether a data record is unique or a duplicate by grouping on one or more specified fields, then sorting on those fields.

Configure the Tool

Column Names: Select the columns where you want to find unique values.

  • Use the Select All button to compare entire records. 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.
  • UseĀ Deselect AllĀ to deselect all fields.

Output Anchors

The Unique tool has 2 output anchors:

  • U anchor: The first record of each group.
  • D anchor: The remaining records from each group.

Output Example

Input Data Stream

Field 1 Field Unique
A 1
B 1
C 1
D 2
E 2
F 2
G 3
H 4
I 5

U Anchor Output

Field 1 Field Unique
A 1
D 2
G 3
H 4
I 5

D Anchor Output

Field 1 Field Unique
B 1
C 1
E 2
F 2
Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.