Compare three datatables with master datatable and remove matching values in all datatables

Hi all,

I have three or four datatables with me. i want to find the non duplicate values by comparing the datatable with the master datatable.

please pour some thoughts…


Hellow @nvignesh456

Kindly provide more details about your query and share a sample input file and expected output file. It may help us to provide you better solution


Hi Hari,

datatableName column name
dt1 Container #
dt2 Container Number
dt3 Tank No

i would like to compare the above data table with DtMaster datatable columnName “Container no”. I need unmatching rows in dt1,dt2 and dt3 as output

Hi @nvignesh456

check below workflow for the Sample like yours…
u can use this! (181.2 KB)