How to get the non duplicates based on three Columns in Datatable

[dfilipovic (Dino Filipović)]

@Lakshmi_N,

I can’t find some pretty solution which would work for this, you can only create loop in loop which will compare row with other rows but this will be slower.
Also you can check this forum topic about this, I don’t know if it is a slolution for your problem.

Datatable comparison using multiple columns

@John_Dara find some starter Help, aligned on your Excels Testuse_V2.xaml (22.1 KB) Kindly note: It is just a starter Help it is setup in a conversative way, just to let more easy to enter for the next implementation steps For Datatable Join it is important what is dt1, dt2 Please avoid Topic duplicates like this one:

Cheers,
Dino