unique selection

[AnGi]

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?

[Emil_Kos · Accepted solution]

Hi,

I would use this tool combination:

[atcodedog05 · Accepted 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 🙂

[Emil_Kos]

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]

Hi @AnGi 

I guess sample tool then.

@Emil_Kos  Hmm, interesting that you brought it up, i think its sorting the groupby column not value column. Can you provide a usecase where it would create issue.

I just want to get a better understanding of this 😅

[Emil_Kos]

@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.