How to use join data table activity to get values that don't join

Hello guys,
So i have been using join data table activity i use it to join dt1 with dt2 , where a column named reference are equal. and my output is dt3.
But this time i want to get a datatable that contains rows from dt1 and rows from dt2 that do not have same values in their reference column

Thanks guys

@David_Oku
find a demo xaml here:
Get_MatchingNonMatching_JoinActivity.xaml (13.7 KB)

2 Likes

Hello,
Thanks a lot @ppr it tried your sequence . here is what i am trying to achieve. in separate excel sheets . i had to make everything in one excel sheet just for the purpose of this screenshot.

Thanks a lot

@Yoichi @Palaniyappan hey guys …please help me look at this too

@David_Oku
find demo xaml for your case here:
Match-NonMatch_2Col_2ResultTabs_JoinActivity.xaml (18.2 KB)

kindly note:
the row order in dtMatch, dtNonMatch is different:
grafik
grafik

changing this you would just edit the logic on how the rows are taken from dtMatchFiltered, dtNonMatchFiltered

2 Likes

@ppr Thanks a lot. you have really been helpful . everything worked fine now, thanks to your last sequence very much appreciated

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