Grabbing Unique Values from Excel

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?

@csewall3

You can use remove duplicate rows activity

Thanks,
Aman sheik

Hey @csewall3,

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

1 Like

@amarasto which interface would i input this command in

variable test should be of type System.collections.Generic.Ienumerable