Get value one time. (Delete duplicate value)

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?

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.

1 Like

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()
1 Like

Hi @hoseongwon

Please try this

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

1 Like

Thank you for your solution. It works

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