Dear RPA developers,
I am very new to RPA and I am having some trouble issues regarding Duplicates.
Imagine this list I imported from an excel file to a DataTable. This list has many columns, each with different information. As an example I’ll mention column A and column D. Column A has the names of the projects, while column D has the dates of the projects. The problem is that there are several projects with the same name and different dates.
What I want is, in case there are projects with the same name, to keep the one with the most recent date and eliminate the oldest ones.
I hope you guys can help me =D