Hey y’all I’m trying to filter out repeated order numbers for my process automation in Excel. Do you have any idea on how to remove duplicates of one column?
You can use remove duplicate rows activity
dt.AsEnumerable().Select(r=> r.Field(“Your Column name”)).ToList().Distinct();
This will give you the distinct values from your datatable column.
Thank you! last question: where would i find the interface to input that command?
Put it inside the assign activity in uipath and the variable should be of type List
@amarasto which interface would i input this command in