This seems to be the joining table concept.
Try to make outer join in tableau when you connect to data.
For more details please watch youtube joins in tableau this will solve the issue i guess.
1 of 1 people found this helpful
You can easily achieve this. The thing is that if you have these 2 tables in a single file, you can directly perform join.
to join the tables, please follow the steps:
1. Drag 1st table in the canvas after importing the data.
2. Drag and drop the 2nd table besides 1st table. Automatically, join is done. You can change the type of JOIN according to your wish.
Now, the other scenario is that if you have two tables as separate data sources, you can blend both using common key and then use accordingly.
Steps to Blend:
1. Connect to 1st data source.
2. Click on the icon of "New Data Source" and connect that too.
Finally make the relation based upon common key.
s. I hope this will
I am attaching Screenshots for both ways. I hope this will help you.
Links to Help:
A quick question what is source of your data? excel or any db like oracle, my sql....so on.
Lets say If your data source is excel and all the data resides in a single excel workbook then you can use join or use Custom sql with legacy connection to join. Rahul has already mentioned that in his reply about joining and blending. Blending has some limitations. After knowing the nature of the sources we can decide which to use.
If your data resides in any db like oracle then I would suggest join both the sources using sql statement and create a system view of that. Then connect to tableau.
Feel free to ask If you've any query.