Hello,
I have a problem with UiPath on the deletion of duplicates, to make things easier I asked the robot to make it simple and to do the process on excel directly, only problem the column that I use to sort, is out of field in the window of selection of duplicates, to do it well it would be necessary that the cursor of the mouse goes down the display until the box to select appears, does UiPath know how to do that ?
Thanks
Hi @frederic-f.bonnet ,
Could you let us know what is the operation that you are trying to perform ?
If you are trying to perform UI operations on an Excel data, then we would recommend you to use Excel / Workbook related activities which would perform the same operations in the back end.
In the image below, we can see the selection box to choose which parameter will be used to delete the duplicates, in my case (No Facture SD). but as this box is not directly accessible by the robot it stops.
How can I do, either I enlarge the window, or I use the scroll down. But, I do not know if it is possible with the robot.
If you want to remove duplicates from “No Facture SD” .You can use this Query
Dt_1= Dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String (“Duplicate_ColumnName”)).Select(Function(g) g.First).CopyToDataTable
Hope this works,
Best Regards.
@frederic-f.bonnet do you have this activity in your UiPath Studio?
