Unique ToolUnique ToolThe Unique tool distinguishes whether a data record is unique or a duplicate by grouping on one or more specified fields, then sorting on those fields.
Select the field or fields to group by. Select All to compare entire records.
The data is sorted based on the Unique fields. 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.
The Unique tool has two outputs. The U (Unique) stream and the D (Duplicate) stream. The first record in each group is sent to the Unique output stream while the remaining records are sent to the Duplicate output stream.
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 |
©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.