Unique records in a set by latest date

[Tessa_Gable]

Hello,

I need to de-dup a file before using it in my workflow.  I have duplicate id's in sets with different dates but not every id has a duplicate.  What I want returned is if there is a duplicate, I want the set with the most recent date and any unique records regardless of the date. I'm close but missing a step somewhere.  Any help would be appreciated.

This is the expected result of the attached file.

SET	DATE	ID
mmm	7/1/2020	123
mmm	7/1/2020	466
rtr	7/1/2020	776
rtr	7/1/2020	898
qzq	4/1/2020	545
qzq	4/1/2020	111

[JosephSerpis · Accepted solution]

Hi @Tessa_Gable I mocked up a workflow that produces your output you describe. Let me know what you think?

[kumaranvr1984 · Accepted solution]

Hi,

Hope this helps.

Regards,

Kumaran