Can you reverse the join (blend?) so that Excel is your primary?
The idea is that the data source that has ALL the data you want to work with should be on the left side. I assume you're doing a blend on these 2 data sources, correct?
If neither source has all the data you want to blend on, then you need to artificially create a "scaffold" file that DOES have the complete set of join/blend values and connect the 2 existing data sources to THAT file.
Thanks for the quick response, Michael. I am blending these two data sources.
I tried using Excel as the primary and I kept getting errors when I tried to add the cube. It said one or more fields use an unsupported aggregation. I couldn’t get anything to work.
Let me look into the “Scaffold” option. I’ve found a couple examples in the forums.
Thanks for the suggestion.
I have a suspicion that a cube source has to be the left side of a blend but I have very little practical experience with cubes. Much depends on exactly how the source data is being summarized/aggregated and whether or not Tableau can properly interpret it to use it in a join or blend. I suspect that is what is going on with your issue.
What is the cube type, out of curiosity: SSAS? SAS? SAP?
I’m not sure, but I think it’s a Redshift cube. It was built by outside developers. I’m pretty new to Tableau.
OK - this should be do-able. At some point, if you can't figure out the blocker yourself, you'll want to grab some sample data and upload a TWBX file so we can see what the issue is.
I got it to work using a scaffold file. I now have all of the data.
Thanks again for the suggestion. Have a nice Thanksgiving.
The same to you! Glad you got it working.