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

Learn Academy Feedback
1

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

2

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

2 Likes
3

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.

image
image1396×560 47.7 KB

Thanks a lot

4

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

5

@MasterOfLogic
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

3 Likes
6

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

7

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