How to manage duplicate entries

Hi Everyone.

I need help in filtering my data table.

For my scenario I have the table below:

As you can see the highlighted rows are duplicated.

What I need to do is to get only the entry with the newest timestamp and dispose the duplicate one.

Is that possible using Uipath?

Advance thank you for all the answers



Please l

Refer this below link,

Happy Automation :slight_smile:

Use the below LINQ, it will help.

Use the Assign activity with a variable and Data type DataTable

dtInput is the output if excel read range.

(From dt In dtInput.AsEnumerable
Group dt By Empid =d1(“ColumnName") Into Group
Select Group.Last()).CopyToDataTable