You might think about the way the study matches together and exactly what inquiries we need to respond to, in place of how-to blend the details otherwise make up for artifacts regarding data source.
Alternatively, dating is the brand new, flexible treatment for give data together out-of numerous supply. Current methods are not disappearing, and are usually nevertheless helpful in particular issues.
- Matchmaking, region step 1: Unveiling the brand new study modeling in Tableau http://datingranking.net/tr/jeevansathi-inceleme (Hook up reveals in the an alternative screen)
- Matchmaking, area 2: Tips and tricks (Hook opens from inside the another screen)
- Matchmaking, area step three: Inquiring questions around the multiple relevant tables (Hook opens up inside a different sort of window)
Use Relationships
This subject treks courtesy building a connected databases and making use of one to own research. If you’d like to check out collectively, you might obtain the latest Bookshop studies lay (Connect opens up into the a different sort of window) . Prefer Bookshop.xlsx towards intense study first off from scratch, or MinimalBookshop.tdsx before everything else the new relevant databases maxims configured getting you.
Video: Migrated Investigation
For people who unlock an existing workbook off a past style of Tableau (version 2020.step 1 otherwise earlier) inside Tableau 2020.2 otherwise after, important computer data resource case you are going to reveal a great Moved Analysis desk.
You’ll find several video inserted within this point. For your benefit, an effective transcript exists throughout the expandable section underneath for each and every videos.
For individuals who unlock a great workbook made before matchmaking was basically offered (in advance of version 2020.2), your computer data provider looks other. In the event the there have been inserted or unioned dining tables, they look as one analytical dining table titled Moved Study. Twice mouse click to see the root dining tables-they truly are nonetheless truth be told there, as well as your analysis usually nevertheless behave as expected.
Keep in mind that whenever you are using only the newest Migrated Analysis dining table, the data pane acts more like earlier incarnations of Tableau Pc.
Once you’ve additional relationship on the research model, the knowledge pane reputation towards the the fresh new design, having size and you can procedures was able inside for each table, together with Migrated Data desk are demonstrated due to the fact a single, merged dining table.
Video: Associate tables
To build a data source from relevant tables, relate solely to your computer data and you will pull a table into the material. Drag out an extra desk. A love usually instantly function in the event it is. When the Tableau dont discover the related areas, you happen to be motivated to pick them oneself.
Brand new fabric you will be enjoying was an alternative level of your investigation design where you could connect dining tables with her. Dragging out additional tables adds these to the data design. The brand new noodle reveals hence tables are related.
Matchmaking might be predicated on computed sphere. It is possible to identify exactly how fields can be compared by using operators once you determine the partnership.
Include joins
You can create a join by double hitting a desk to open the fresh register canvas (referred to as the fresh physical level), then dragging out a desk in order to make a hop on. Creating matches is the same feel as the earlier versions off Tableau-you could potentially place a join clause, along with a computation if required, and arrange brand new join type of.
Once you close this new signup material, the latest table into relationships canvas (also called new logical coating) features a hop on symbol to point the root sign-up. For the reason that a join merges their dining tables along with her to create just one, the fresh dining table. Related dining tables remain line of.
Create unions
Incorporate unions of the dragging out The newest Partnership. Unions, like touches, indeed mix the knowledge, and have a symbol toward logical layer. I encourage usually renaming unions-otherwise one dining tables with not sure labels-so you can some thing a great deal more of use.
Video: Abilities Choice
For all the relationship, discover abilities choices including associated sphere. Tableau automatically decides safe non-payments for these selection. But not, when you’re clear on the characteristics of your investigation, modifying these types of selection will give Tableau details on how best to most useful configure automatic touches during the studies. Mode new cardinality and you will referential integrity possibilities provides Tableau details on how to enhance questions.