How to delete duplicates row from excel

Help Activities
, ,
1

Hi all,

Someone tell how to delete the duplicates rows from the excel.
LMS_User_ID_Creation_Format.xlsx (8.4 KB)
From the attached excel i need each data only once rather than multiple time.
Anyone help me to resolve the issue.

2
EMP_ID * Name * Email * Mobile * Alternate_No Job_code * Location_code * Supervisor_code * Last_working_date is_active Action * Domain_id *
1234 Naveen.S Naveen.S@gmail.com 1234567890 4321 5678 7890 Y Update Naveenkumar.S.clo
4321 Navin.S Navin.s@janabank.com 8976543211 7890 4567 6789 y Update Navin.s.clo
4321 Navin.S Navin.s@janabank.com 8976543211 7890 4567 6789 y Update Navin.s.clo
Jfs1234 Navi Navi@gmail.com 1234567890 78909 7865 jfs4567 Y Navi.s
Jfs1234 Navi Navi@gmail.com 1234567890 78909 7865 jfs4567 Y Navi.s
![image 690x2](upload://r0a6nq7u5JJrW5aFixSvo20JKLc.png)
3

Hi!

try this

dt.defaultview.ToTable(True,[ColumnName]).CopyToDataTable

Regards,
NaNi

1 Like
4

Hi,

Use read range to read the excel data into data table.

use remove duplicate rows activity it would help you to remove duplicates from data tabe.

Finally use write range to write back into new sheet in your excel. thanks.

image
image581×574 14.6 KB

image

1 Like
5

Hi @HeartCatcher

Check the thread below to achieve it using LINQ!

Regards

1 Like
6

Hi,

Hope the following sample helps you.

img20211129-6
img20211129-6649×605 14.5 KB 

dt = dt.DefaultView.ToTable("",True,dt.Columns.Cast(Of DataColumn).Select(Function(c) c.ColumnName).ToArray)

Regards,

1 Like
7

Thanks all for your sincere replies, apart from your answer just I had found another easy way to delete the duplicate rows using the balareva activity as in the screen shot

image
image1366×768 107 KB

2 Likes
8

Hi do you need to install a package for this activity?

9

yes you should

10

okey thanks, dont forget to attach the pacakages if you can and mark it as the solution
thanks

regards
ahmad