
1. Re: How to data model in Tableau?
diego.medrano Apr 19, 2017 4:45 PM (in response to Matthias Winkler)1 of 1 people found this helpfulHey Matthias,
Welcome to Tableau and welcome to our forums! In our product help we have many of the options available to you for preparing your data:
However, the more specific a question you ask, the better an answer you'll get. Give our unions and joins a try, and if you hit any snags, let us know and we can try to help you move past it.
Thanks for posting,
Diego

2. Re: How to data model in Tableau?
Matthias Winkler Apr 20, 2017 7:08 AM (in response to diego.medrano)Hey Diego,
thanks for your reply. My task would be the following:
Table 1:
Sales ID Customer Month Product 1 Company A 1 Product XY 2
Company B 1 Product YZ Table 2:
Sales ID Customer Month Product 3 Company C 2 Product XY 4
Company A 2 Product YZ Table 3:
Sales ID Product Price 1 Product XY $100 2
Product YZ $200 3 Product XY $150 4 Product YZ $300 My database is Table 1, 2 and 3. Table 1 and 2 need to be unioned since they consider different months. Then, Table 3 needs to be joined to this unioned table. But since the same products are sold with different prices, it has to be joined on a concatenated key consisting of "Sales ID" and "Product", e.g. "1_Product XY" for the sale of Product XY to company A in month 1. The final table would be:
Sales ID Customer Month Product Sales ID_Product Price 1 Company A 1 Product XY Company A_Product XY $100 2
Company B 1 Product YZ Company B_Product YZ $200 3 Company C 2 Product XY Company C_Product XY $150 4 Company A 2 Product YZ Company A_Product YZ $300 Please note that this a very simplified example and in reality there are 3 further tables, which need to be joined on individual (concatenated or modified) keys. In addition, usually more than one product is assigned to a Sales ID. As already mentioned, all tables come from different excel files.
I'm generally familiar with joins, unions and so on but I'm unsure where to solve this problem in tableau.
Thanks in advance!
Matthias