Filtering out the duplicates

[sgaryali]

Hi

I want to take unique value on the basis of Date and Employee ID.

I know for that I can use Unique tool but I want to take on the bases of third column.

Which is Created Date

I want to take the latest date row from Created Date column.

For ex

For date -

3/5/2022

For Employee ID

101

I want to take row number number 7 which is 4/16/2022 as it it the latest date.

How can we do this?

Thank you in advance :) 

[IraWatt]

Hey @sgaryali,

You can use the summarize tool and use MAX in the created date field to ensure you get the latest date for each unique employee and date:

[sgaryali]

Hi @IraWatt 

Thank you for your reply.

Your solution is working totally fine with the provided input file by me.

But there is one more column that I forgot to add because of that column I am not getting desired results.

I am attaching the updated file please have a look and help.

Thank you :)

[IraWatt · Accepted solution]

No worries @sgaryali, I've added a join tool so that the extra data is always added: