Find uncommon rows by comparing 2 datatables

Help Community
,
#1

Hi,

I am having 2 datatables, one is having data of queueitems which has status as new and one datatable is having data which i need to push to queues. But before pushing, i want to compare both datatables to avoid adding duplicates. For that i am using dtQuery.AsEnumerable().Except(dtInputQueue.AsEnumerable(),DataRowComparer.Default).CopyToDatatable
to find uncommon data. But still it is adding duplicates. Please Help

#2

Mandatory for the Except Set Operator is that both datatables do have the same datacolumn structure.

Is this ensured?

In case of a duplicated row is not detected then we would recomment one row for this case and check on column value level for differences (also trailing spaces etc).

Let us know the result from this Analysis afterwards