Variable IEnumerable<Object>

[leo.horodenko (Leonardo)]

I’m using this type of variable to get the values of a collumn from a “.xlsx” file. Now i need to filter, cause some values are equals, so they’re duplicated. Someone ?

[Afrikyan]

Hi, @leo.horodenko
Easy way for solve this problem
Read column from xlsx to DataTable, and then use “Remove Duplicate Rows”

[Vara (Varaprasad Rao)]

Try to Use:

Variable.Distinct to remove Duplicates

[Palaniyappan (Forum Leader)]

Hi
Welcome to UiPath community
Kindly have a view on this For more insights

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Cheers @leo.horodenko

[pattyricarte (Patty Boy)]

Hi @leo.horodenko

You can read this article for your reference.

How to identify duplicates UIPATH

cheers

Happy learning