Col A Col B
123 XXXXXX 21 H
123 XXXXXX 21 H
123 XXXXXX 21 H
125 XXXXXX 8H
125 XXXXXX 8H
125 XXXXXX 8H
125 XXXXXX 8H
125 XXXXXX 8H
555 250h - 24 XX
555 250h - 24 XX
555 500h - 24 XX
555 500h - 24 XX
555 100h - 24 XX
555 100h - 24 XX
What excpted as result :
Col A Col B
123 XXXXXX 21 H
125 XXXXXX 8H
555 250h - 24 XX
555 500h - 24 XX
555 100h - 24 XX
What I get after using my query :
Col A Col B
123 XXXXXX 21 H
125 XXXXXX 8H
555 250h - 24 XX
(From d In DtBuild.AsEnumerable
Group d By k=d("Col A").toString.Trim, k2=d("Col B").ToString.Trim Into grp = Group
Let ra = New Object(){k,k2}
Select r = DtOutput.Rows.Add(ra)).CopyToDataTable
with looking only to column B the Duplicates are too wide clustered:
vs
As your sample data shows 2 cols and duplicate detection now affects all columns essential deduplications can be done like Remove Duplicates Activity or
I’m sorry, after trying on the real excel file, it doesn’t work quite as expected, since I have multiple other columns, that I didn’t mention, didn’t think it will matter.
I have tried that activity before, it didn’t quite work for me, because I have other columns that I didn’t mention, I didn’t think it would matter, both solution are not working.
After multiple tries, It failed to work, but I got an idea thanks to ours last discussion, I removed alll the unnecessary columns, which at the end left me only with 4 columns, so than later i do the linq query to remove the duplicates, it works at last