SOLVED
Unique Tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ryanfreyre
5 - Atom
‎10-12-2022
01:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
‎10-12-2022
02:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
21 - Polaris
‎10-12-2022
02:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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