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 ?

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

Try to Use: Variable.Distinct to remove Duplicates

Hi Welcome to UiPath community Kindly have a view on this For more insights [image] DataTable filtering with expressions Tutorials Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName…

Hi @leo.horodenko You can read this article for your reference. [Brian Smith] How to identify duplicates UIPATH datatable, uipath asked by Brian Smith on 04:20PM - 13 Sep 19 UTC cheers :smiley: Happy learning :smiley:

Variable IEnumerable<Object>

Help

Palaniyappan (Palaniyappan P ) December 30, 2019, 2:41pm 4

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

Cheers @leo.horodenko

Topic		Replies	Views
How to Remove Duplicate Columns in Excel and have the distinct values in the other sheet Help datatable , excel , activities	7	6478	October 9, 2018
How to remove duplicates entries from Row and it should remove that entire Column Help datatable , activities , question	20	3144	November 27, 2019
I want filter the data table and take unique data table Studio datatable , activities , studio	13	585	February 12, 2024
How to remove duplicate entries from a particular column in excel file using UI path Studio Studio uiautomation	2	737	April 29, 2022
Remove duplicate rows from Excel and Datatable in UiPath \| 4 methods Video Tutorials excel , activities , faq	0	804	August 23, 2022

Variable IEnumerable<Object>

Related topics