Grabbing Unique Values from Excel

[csewall3 (Christian Sewall)]

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?

[aman_sheik]

@csewall3

You can use remove duplicate rows activity

Thanks,
Aman sheik

[amarasto (Aman Rastogi)]

Hey @csewall3,

dt.AsEnumerable().Select(r=> r.Field(“Your Column name”)).ToList().Distinct();

This will give you the distinct values from your datatable column.

[csewall3 (Christian Sewall)]

Thank you! last question: where would i find the interface to input that command?

[amarasto (Aman Rastogi)]

Put it inside the assign activity in uipath and the variable should be of type List

[csewall3 (Christian Sewall)]

@amarasto which interface would i input this command in

[amarasto (Aman Rastogi)]

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