Unmatched records using LINQ

Help
, ,
21

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

5 Likes
22

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

@Palaniyappan @ppr @lakshman

23

Anyone ?

@Palaniyappan @ppr

1 Like
24

@hasib08
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
25

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

@ppr

26

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