Remove duplicates from two columns

[Jnanesh_Ballal]

Hi,

I have a data table DT1 with two columns

DT1 :

I need a solution which removes duplicates from both the columns.

Thanks in Advance.

[Harshith_Adyanthaya]

Hi @Jnanesh_Ballal,

You can use remove duplicate rows activity.

Or

DataTable1 =DataTable1.DefaultView.ToTable(true,“country_1”,“country_2”)

[Yoichi]

Hi,

Can you share expected output?

Regards,

[Jnanesh_Ballal]

Expected output

[Anil_G (Anil Gorthi)]

@Jnanesh_Ballal

First first column dt.DefaultView.ToTable(True,"Country_1")

For second column dt.DefaultView.ToTable(True,"Country_2")

These are to be used in assign and you would get output with single column and unique values

Cheerd

[Jnanesh_Ballal]

Thanks,@Harshith_Adyanthaya
I have used the
DataTable1 =DataTable1.DefaultView.ToTable(true,“country_1”,“country_2”)
but duplicates are not removed

[mohiniganesh15]

Hi @Jnanesh_Ballal
dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r"Country_1").ToString,r(“Country_2”).ToString)).Select(Function(g) g.First).CopyToDataTable

Regards
Mohini

[Jnanesh_Ballal]

Thanks @Anil_G , tried this but only first column appears after removing duplicates.

[Yoichi]

Hi,

Another approach:

Can you try the following sample?

Sample20230410-5L.zip (8.2 KB)

Regards,

[Anil_G (Anil Gorthi)]

@Jnanesh_Ballal

Yes as you dont have a common duplicate…I have you two commands for each and then you can paste the data side by side in your excel using two write range activities

cheers

[Yajnesh_S]

Hi, @Jnanesh_Ballal

Try this one

DT1.AsEnumerable().groupby(Function(a) Tuple.create(a(“Country_1”).ToString.Trim,a(“Country_2”).ToString.Trim)).Select(Function(b) b.First).CopyToDataTable()

Regards,
Yajnesh