We can blend not just two but around 16 different data sources in Tableau.
All you have to do is connect the two data sources with any common field. This is done in the Data Window. For all the common fields Tableau will display a link. You just have to click on it and it will turn to orange color. As like the below image:
Thanks for quick reply, I tried using this, but, unfortunately, this is not working for me. Shows incorrect numbers to me. By doing data source blending field starting showing characters like * instead of numbers, do you know what might the reason for the same?
This behavior is due to a one-to-many, with the many in your secondary data source. An * means you have multiple matches. Please read this KB document.
This should help you.
Yes, there is one to many relationships, but I'm not sure why I didn't see an option to create a primary group.
Is there any other way to fix this. Why Tableau doesn't show up an option to show multiple values against one record?
If a user needs multiple values against one record then? I think this needs to be handled by Tableau.
If you're getting an * that means that the dimension from the secondary source has a finer grain than the primary source (based on your linking dimensions). For us to help you further it would help to have a Tableau packaged workbook .twbx) with some sample data, or at least a screenshot of your view showing all the Shelves as well as the Data window for your secondary data source.