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.
Output example
Input data stream
| Column 1 | Column Unique |
|---|---|
|
A |
1 |
|
B |
1 |
|
C |
1 |
|
D |
2 |
|
E |
2 |
|
F |
2 |
|
G |
3 |
|
H |
4 |
|
I |
5 |
U anchor output
| Column 1 | Column Unique |
|---|---|
|
A |
1 |
|
D |
2 |
|
G |
3 |
|
H |
4 |
|
I |
5 |
D anchor output
| Column 1 | Column Unique |
|---|---|
|
B |
1 |
|
C |
1 |
|
E |
2 |
|
F |
2 |