Unique Tool

[ryanfreyre]

Hello,

when using the unique tool and selecting two columns (Ex. Date and Sale Price), will the tool automatically move any of the same dates to the duplicate anchor? Or does it only move a column with the exact date matching the sale price?

Thanks 

[Felipe_Ribeir0 · Accepted solution]

If you select Date and Sale Price, it will move to the duplicate anchor the duplicated combination of these columns.

Example

Date	Sales
1/1/2022	2000	Not duplicated
1/1/2022	3000	Not duplicated
1/2/2022	40000	Duplicated
1/2/2022	40000	Duplicated

[binuacs]

@ryanfreyre If you select two columns the unique tool only moves if both fields are having a duplicate entry. You can check the Unique tool example in the designer