Excecl Automation remove duplicate rows based on particular Column

Help Studio
, ,
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
Forum Engagement Daily Reports