Remove Duplicates- Take highest number in non duplicate Column

[nicktekippe]

I am trying to remove duplicates in my data based on the last column below for which one to keep. There are duplicates with the same Sup#, FY,and FM with different Quality Impact Points and Matured QPPM data(but also duplicates of those as shown in data below). What I want to do is filter out duplicates and keep whichever duplicate has the highest value in the last column.

[DataNath]

@nicktekippe could you not just use a Summarize tool for this?

Group by your first few fields (whichever ones can be duplicated) - supplier_number, fiscal_year, _fiscal_month, (quality_impact_pts? Not sure, a little confused from the description).

Then use the Max function on current_fiscal_month_matured_data_quality_ppm

[Kwebb · Accepted solution]

If I'm understanding correctly, this should be pretty simple. Just sort your data descending on the last column and then use the "unique" tool to capture the first instance of the unique records

[nicktekippe]

@DataNath @Kwebb Thank you for the ideas it is working as intended now. Sorry if my description was a bit confusing I was having trouble wording what the issue was.