Remove duplicate based on a column but only for specific rows

[ravindar.singh (Rav Singh)]

Hi want to remove duplicates based on a column name but only need to remove value from specific row ( where component is TRS).

Currently using this but its not giving me the outcome I want

out_FeesDataTable.AsEnumerable().GroupBy(Function(r) r.Field(Of String)(“Combined Start Date”)).Select(Function(s) s.First()).CopyToDataTable

Input

Thanks in advance

[kvssnid (Keerthivas)]

DataTable.Select(“ColumnName=‘TRS’”).CopyToDataTable

Will do it right.

You will get a DT which has TRS, then take a distinct of that DT

[ravindar.singh (Rav Singh)]

@kvssnid thanks for the response.
Sorry If I didn’t explained properly. I want to compare Combined start date column and only need to remove TRS if they are duplicate.
For above pic(example) it should only remove TRS1

[kvssnid (Keerthivas)]

Compare component start date with ?

[ravindar.singh (Rav Singh)]

My end goals is - If TRS combined start date matches with any FLT combine start date I want to remove it.