Blending takes place after all the dimensions in the worksheet are set and is always an aggregation at the level of the link - the data from the secondary source are aggregated as they are brought into the worksheet for use in primary -
That is why you get the * there is more than one string items (note -if the values are numeric then sum() is the default aggregation)
so what to do - you can fake a union see https://evolytics.com/blog/hacking-cross-database-unions-in-tableau-use-case-summary-and-tutorial/
Thank you for the quick reply Tim but unfortunately this doesn't answer my question.
The link you sent, mentions to create a join. This is - so far I know - not possible for (1) tableau server combined with (2) excel....
did you try it -
scroll down to
The Solution: Using cross-database join to build a union
Yes I tried it. It is like I mentioned not possible to join with a Tableau Server datasource
>> Cross database joins are not possible with published (Tableau Server) datasources.
That is why I have to blend the data. Unfortunately, this results in a situation where, as you can see in my first post, the data is not connected properly. Do you happen to have any other ideas on how to solve this issue?
Maybe the following helps to explain what I need:
a full join through blending.
Amber, that's not possible. Blend = Left Join (more or less). That's the only option.
HOWEVER, maybe we can get creative. Do you have Prep? This might be possible with Prep...
At worst, you could use Prep to output a CSV that looks like the Tableau Server data source, and use THAT to do your full outer join (or union or...).