Unmatched records using LINQ

then you have to switch to:
dt2 except commonrows
Find demo here,
hasib08_II_0.3.xaml (11.0 KB)
take care about the renamed variables, do not copy paste blindly

EDIT: 0.3 Version is returning dt2 rows from Common rows check, should be more safe at your end


How to join 3 tables and get unmatched value from it?

@Palaniyappan @ppr @lakshman

Anyone ?

@Palaniyappan @ppr

1 Like

Just some delayed answer, due holidays Off.
Regardless how much Tables or Others the Implementation is Always aligned in details. Es.g No of cols…

Joining three Tables can be done as similar

1 Like

3 Tables and columns are fixed.

(From d1 In DT02.AsEnumerable
Join d2 In DT03.AsEnumerable
On d1(“number”).ToString Equals d2(“number”).ToString And d1(“amount”).ToString Equals d2(“amount”).ToString
Select d2).CopyToDataTable

After joining how to copy only selected columns in the output result.
i.e only “number” and “amount” in the finalDT


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.