How to manage duplicate entries

Learning Initatives Reboot Your Skills 2021
1

Hi Everyone.

I need help in filtering my data table.

For my scenario I have the table below:

image
image1333×181 14.8 KB

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

Regards,

Alvin

Please l

2

@Alvin_Apostol1
Refer this below link,

Happy Automation :slight_smile:

4

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