How can you search duplicate cell in one column with C# expression?

I’m trying to find the duplicate cell in one column and to delete that when the other column is blank.


Use below expression for filtering the duplicate values

dtYouDatatable = dtYourDatatable.DefaultView.ToTable(True,“ColumnName”)

Now you can use Filter datatable activity to check the other column is not blank

Hope this may help you


Will try it thanks alot