Get value one time. (Delete duplicate value)

[hoseongwon (호성 원)]

Hi.

I want to make first datatable to second datatable.

1st

Apple fruit
Apple fruit
Apple fruit
Bear animal
Bear animal
Rice grain
Rice grain
Rice grain

2nd

Apple fruit
Bear animal
Rice grain

How can I delete duplicated value?

[supermanPunch (Arpan)]

Hi @hoseongwon ,

Could you try using the Remove Duplicate Rows Activity ?

This needs to be done after you have read the data as a Datatable.

[ptrobot]

You can test with LINQ. If your datatable is named dt, use an Assign activity with below expression:

dt = dt.AsEnumerable().GroupBy(Function(row) row(0).ToString).Select(Function(grp) grp.First()).CopyToDataTable()

[Gvivek9889 (Vivek Gupta)]

Hi @hoseongwon

Please try this

DT.DefaultView.ToTable(True,“ColumnName”)

[hoseongwon (호성 원)]

Thank you for your solution. It works