How to remove duplicates rows data from data table

Learning & Development Programs Automation Starter
1

i have 5 duplicates rows in one column , but i want to remove 4 records and keep only one record

2

Hello @T_Y_Raju

You can use Remove Duplicate Rows activity.

3

remve duplicates will remove the entire duplicates, but my requirment is i want to keep one record…

4

Did you try using it?

5

Hi @T_Y_Raju,

You only want to do it for one record, other renewals can stop, is it true?

Regards,
MY

6

yes i used …entire duplcates are getting removed

7

Check the below doc. You can do like that.

8

No, it won’t.

9

image
image746Ă—418 35 KB

what is i and g stands for…plz explain this linq query completely

1 Like
10

Hello,

if entire duplicate rows are being removed I can only think it may be something to do with extra processing you are doing after the activity.

However there is another way to do it, create a copy of your datatable and then in a for each loop filter the datatable to find the number of duplicate rows. If it is a duplicate row then delete that row from the copy of your datatable.

11

Those are arguments for the ad hoc functions.

12

@T_Y_Raju

Those are the variable inside the linq query and you dont need to separately declare it.

It will group the table with the rows. So if there are duplicates it will get removed by keeping only one value.

Alos you can group activity in uipath.

13

my req is

Raju 123
Raju 456
Raju 123
Raju 123

here i want only 1 row rest 3 i want to delete

14

i did no get can u show me with example

15

this linq method …iam not able to understand clearly

16

Hey!

Try like this.

Dt = dt.defaulview.ToTable(True,"Column Name)

Try this and let me know!

Regards,
NaNi

17

Hi, I had the same issue, try this

(From d In DT.AsEnumerable()
Group d By k1= d(“NAME”).toString.Trim
Into grp=Group
Select grp.First()).CopyToDatatable()

3 Likes
18

If you select all your rows then this is not going to happen just select single row and remove it, hope this will help you but it will also take time.

19

Thx so much sir, this Linq query is great!

20

Hi @T_Y_Raju
Try this:

yourDataTable = yourDataTable.AsEnumerable().GroupBy(Function(row) row.Field(Of String)("yourColumn")).Select(Function(group) group.First()).CopyToDataTable()

Hope it helps!!