I need to remove the dupicate row from excel, I tried the regular way at that time wght 170 is delecting. I need to keep wght 170 row and delete with respect to the SONum

Help Activities
, ,
1

image

2

@alex_joshy
Welcome to the community

Can you please try this

dt = Dt.AsEnumerable.GroupBy(function(x) x("SONum").ToString).Select(function(x) x.First).CopyToDataTable

Use this in assign

Cheers

1 Like
3

@alex_joshy Hi
The DefaultView property returns a DataView you can use to sort, filter, and search a DataTable.

For Example :We can use the simple DefaultView Code to To Remove Duplicates From Datatable In UiPath

dataTable new_dt =
old_dt.DefaultView.ToTable(True)

Note:
Useful when we are removing duplicates with respect to every “Column”

1 Like
4

Thanks its worked

1 Like
5

@alex_joshy

Please mark the solution if resolved, so that others also can get help

Happy Automation

Cheers

1 Like
6

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