Full Join - compare datatable 1 with datatable 2 - return matching and not matching items

[ppr (Peter Preuss)]

@Karan28
the Join activity did a good job for doing the full Join

Linq was helpfully for bring it into the target structure:

(From dj In dtJoin.AsEnumerable
Let c1 = If(String.IsNullOrWhiteSpace(dj("Column1").toString), dj("Column1_1"),dj("Column1"))
Order By c1
Let ra= New Object(){c1,dj("Column2"), dj("Column2_1")}
Select dtResult.Rows.Add(ra)).CopyToDataTable

Find demo XAML here:
FullJoin_TotalColResult_JoinActivity.xaml (12.2 KB)