How to Remove duplicate rows in columns and delete it

[suraj_gaikwad]

@Shiva_Nikhil

Still it’s not working

[Shiva_Nikhil]

@suraj_gaikwad

can you share the exact excel file one more time so that i can send you the code again

[suraj_gaikwad]

Again DOC-20231016-WA0016.xlsx (8.5 KB)

We can check with case id also bcz of the case id are same u can check the excel sheet for refresh

@Shiva_Nikhil

[Shiva_Nikhil]

@suraj_gaikwad

just use the below code

dt.AsEnumerable.GroupBy(Function(r) r(2).ToString).where(function(grp) not grp.Any(function(a) a(“Match Type”).ToString.trim.Equals(“Confirmed”))).Select(function(g) g.copytodatatable).toarray

for making group you need to mentioned a column which is having all the values in it

every thing is working fine

hope this helps

[suraj_gaikwad]

Can you elaborate more so can I understand clear

Thanks

[suraj_gaikwad]

@Siva_krishna_Thumma

What did you passed in for each?

[Siva_krishna_Thumma]

Hey,

Group_List variable type would be

for each CN would be