Removing duplicates based on max of another column

[shravanvijayaprasad]

Hi,

I have a table that looks like this

SortID	ID	Name	City
1	1	xxx	NYC
2	1	xxx	Seattle
3	2	yyy	DC
4	3	zzz	Pittsburgh

How do I get the output to look like this? (I need to get the highest sortID for each of the ID and get that row alone)

ID	Name	City
1	xxx	Seattle
2	yyy	DC
3	zzz	Pittsburgh

[JosephSerpis · Accepted solution]

Hi @shravanvijayaprasad  I mocked up a workflow let me know what you think?

[AbhilashR]

@shravanvijayaprasad  - attached solution should help

[shravanvijayaprasad]

@JosephSerpis  thanks, this worked!