Take a look at the attached packaged workbook which I believe produces the result you are looking for.
1. Connect to data set 1
2. Connect to data set 2
3. Create a calculated field that references fields from both data sets:
Hope this helps!
CombinedSets.twbx.zip 9.8 KB