Remove duplicates from Excel based on single column

Help Activities
, ,
1

Hi Team,

Below is the input file

input.xlsx (10.1 KB)

From the above input file i need to remove duplicates from column 1(MAIN_FORM_REQUEST_ID)

Please help me with solution

Thanks in advance
Likitha

2

Does Excel Remove Duplicated Command not working?

3

Hi @vinjam_likitha

If there is duplicate value in column 1, how u want the remaining column data.

image
image1335Ă—101 12.9 KB

Which row u want in the output.

Can u share sample output file?

Based on your requirement use this query.
dt_input=dt_input.AsEnumerable.GroupBy(Function(x) x(“MAIN_FORM_REQUEST_ID”).ToString).Select(Function(y) y.LastOrDefault).copyToDataTable()

dt_input=dt_input.AsEnumerable.GroupBy(Function(x) x(“MAIN_FORM_REQUEST_ID”).ToString).Select(Function(y) y.FirstOrDefault).copyToDataTable()

4

Hii @vinjam_likitha
Try this one,

(
From row In DT_Input.AsEnumerable
Group row By a=row(“MAIN_FORM_REQUEST_ID”).ToString.Trim Into
grp=Group
Select grp.First
).CopyToDataTable

Using Group function This might help .

5

Hello you can use group by method from linq
and try this

DataTableOuput.GroupBy(
Function(p) p.Columname).CopyToDataTable

6

Hi,

I was not considering other column data only i want
first cloumn data in the output file by removing duplicates.

Thanks
Likitha

7

Hi @vinjam_likitha
Try this query.
dt_input= dt_input.DefaultView.ToTable(True,“MAIN_FORM_REQUEST_ID”)

1 Like
8

Hi

Thanks @Suraj_B_Shetty for the solution

Thanks @MuralidharVankamaddi @Jithesh_R @pawanrajpurohit

9

@vinjam_likitha ,

Take a look at this XAML.
Remove_Duplicate_Rows.xaml (5.9 KB)

Done exactly as you wanted !

10

Thanks @arjunvyshnav

1 Like
11

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