Hi:) ı want to remove duplicates just “year”,“month”,“customer no” columns in my data ı want to this for my data [image] how can ı do that in uipath? dataSample.xlsx (9.5 KB) regards…

@burcu_argun Give a try on following (From d1 In dtData.AsEnumerable Group d1 By y=d1(“year”), m=d1(“month”), cno=d1(“customerno”) Into Group Where Group.Count = 1 Select Group.First()).CopyToDataTable it should retrun all rows that have an unique year, month, customerno combination please up…

Remove Duplicates Specific Column

Help

Manish540 (Manish Shettigar) January 10, 2020, 12:27pm 8

This link may help you,

Topic		Replies	Views
How to remove duplicate values in a specified column in a datatable? Studio activities , question	5	451	July 30, 2023
REmove duplicates from datatable excel Help datatable , activities , question	13	2605	November 14, 2019
Remove duplicate rows from a column Help excel , activities	6	4918	January 26, 2019
How to Remove Duplicate Row If the Value from two Columns matched Activities excel	5	3512	March 13, 2022
Remove duplicates from excel file Help	9	5293	June 3, 2022

Remove Duplicates Specific Column

Related topics