Excecl Automation remove duplicate rows based on particular Column

Help Studio
, ,
1

Hi Mates,
I have an excel in which we have multiple rows which are duplicates.
if i do it manually in excel then it possible for us to remove duplicates,But how to perform this in UI path ?
I tried every activity present regarding duplicate and tried default view too but sometime it generates the duplicate row as well. please help!!

2

Hey @akarshan.sonkar there are many ways
1- you can use Remove Duplicate Rows Activity
2- Method - create one variable of datatable - pass the logic – dt(yourvariable).defaultview.totable(“yourcolumn”)
3- Linq Query–dt.AsEnumerable().GroupBy(Function(x) x.Field(Of String)("ColName
")).Select(Function(y) y.First()).CopyToDataTable()

use as per your need

cheers

2 Likes
3

@akarshan.sonkar,

Follow this approach

Input file

A spreadsheet displaying columns for ID, First Name, and Last Name with multiple rows of data inputs. (Captioned by AI)
A spreadsheet displaying columns for ID, First Name, and Last Name with multiple rows of data inputs. (Captioned by AI)374×377 4.52 KB

Code:

A workflow that reads data from an Excel file, processes it to remove duplicates based on an 'ID' field, and writes the refined data to another Excel file. (Captioned by AI)
A workflow that reads data from an Excel file, processes it to remove duplicates based on an 'ID' field, and writes the refined data to another Excel file. (Captioned by AI)1312×790 31.2 KB

Output:

A table with columns labeled "ID," "First Name," and "Last Name," containing five rows of example data. (Captioned by AI)
A table with columns labeled "ID," "First Name," and "Last Name," containing five rows of example data. (Captioned by AI)367×274 3.6 KB

Sample code developed in Studio 2025
ExcelSheetCopy.zip (321.4 KB)

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.