Have you tried a blend? Connect to your data sources individually and then blend them by going to Data > Edit Relationships.
Also, you could try doing this using Custom SQL.
Thanks, I'm trying that now. It doesn't seem let you concatenate fields in the edit relationship.
Unfortunately, I don't have SQL access available. I'm forced to work in excel data sources