Hi guys
I have this table
Name | Value | Address |
Andrew | 1 | Main Street 4 |
Paul | 2 | Cuba street 6 |
Andrew | 2 | St. Church street 2 |
Paul | 3 | Ford street 89 |
I'm using Unique tool to select only one name from column Name, but ho i can be sure that the row with the highest value is selected?
Solved! Go to Solution.
Hi @AnGi
Just to add you can get the highest value as unique selection by sorting value on descending and then applying unique tool. Unique tool always takes first occurrence.
Hope this helps 🙂
Hi @atcodedog05,
I know that a unique tool is sorting the data first which is why I didn't propose this solution.
That is why I am not the biggest fan of relying on the unique tool in situations like this.
@atcodedog05 Sample tool is also sorting the data:
and you cannot be sure that you will get the results that you expect as this sorting will be done only on the value that you have used for the grouping.
If the user wanted to have the max value of something for a certain column I don't think you can be 100% sure that you will get the correct values for a sample/unique tool.