Retain only highest Sequence number

[vinothkumar]

Need help to know how to eliminate sequence number 1- 3 and retain only the highest sequence number

Sequence Number	Product Number
1	467AB
2	467AB
3	467AB
4	467AB

[Christina_H]

It's hard to tell what you're trying to do with so little data, but try sorting in descending order by sequence number then using a sample or unique tool to keep the first row for each product number.

[Gaurav_Dhama_]

Use a summarise tool and Group by product and take max of sequence number.