You can think about the investigation fits along with her and you will what concerns we wish to address, in the place of how to combine the content otherwise make up for artifacts on databases.
Rather, relationships would be the brand new, flexible way to bring research together out of numerous offer. The present actions are not going away, and tend to be however helpful in particular issues.
- Matchmaking, area step 1: Launching the investigation acting in the Tableau (Hook up reveals within the another type of window)
- Relationship, area 2: Tips and tricks (Connect opens in the a new window)
- Relationship, region step 3: Inquiring inquiries across the multiple associated dining tables (Hook opens up during the yet another windows)
Fool around with Matchmaking
This subject strolls due to building a connected databases and utilizing you to to have studies. If you’d like to adhere to along, you could down load the fresh Bookshop studies place (Link opens from inside the an alternative screen) . Prefer Bookshop.xlsx toward brutal data first off out of scrape, or MinimalBookshop.tdsx before everything else the newest relevant repository concepts set up to have your.
Video: Moved Study
For those who open an existing workbook out-of a past types of Tableau (variation 2020.step one otherwise earlier) inside https://datingranking.net/tr/lovoo-inceleme/ Tableau 2020.dos or later, your data provider case you will tell you a Migrated Research table.
You can find several video stuck within this point. For your benefit, good transcript is provided regarding the expandable area underneath for every single movies.
If you open good workbook made before relationships were available (prior to adaptation 2020.2), important computer data provider might look various other. In the event that there had been inserted or unioned dining tables, they appear since the an individual analytical dining table entitled Migrated Studies. Twice simply click observe the root tables-they’re however truth be told there, along with your data have a tendency to still work as expected.
Keep in mind that while you are using only brand new Moved Studies table, the details pane acts more like earlier incarnations of Tableau Pc.
Once you’ve additional matchmaking with the data model, the content pane standing to your the fresh new layout, with proportions and you will methods maintained in this for each desk, and also the Migrated Study desk is showed given that one, merged dining table.
Video: Associate dining tables
To build a databases away from relevant tables, relate to your data and you may pull a table to the fabric. Drag-out a moment table. A romance usually instantly function whether or not it normally. When the Tableau never choose the brand new related areas, you will be prompted to select him or her on your own.
The new material you might be watching is actually a unique level of the studies model where you could associate tables along with her. Dragging out a lot more dining tables contributes them to the information and knowledge model. The latest noodle reveals and this tables are associated.
Relationship should be centered on determined fields. You are able to specify just how fields might be compared by using workers after you identify the relationship.
Create touches
You possibly can make a hop on from the double clicking on a table to start new join fabric (also referred to as the new real layer), immediately after which dragging-out a table in order to make a jump on. Starting suits is the same feel because the earlier versions out of Tableau-you could potentially place a jump on condition, including a computation if necessary, and you may arrange brand new join types of.
Once you personal brand new join fabric, the latest table on the relationship material (also known as the logical layer) has a hop on icon to indicate the root join. It is because a jump on merges its dining tables along with her to create just one, the brand new desk. Related tables are distinctive line of.
Include unions
Incorporate unions from the dragging-out The fresh Commitment. Unions, particularly matches, in fact combine the information and knowledge, and have an icon on logical level. I encourage usually renaming unions-otherwise any dining tables that have uncertain brands-so you can anything much more of use.
Video: Show Alternatives
For the relationship, you will find performance possibilities along with associated areas. Tableau immediately decides safe defaults of these alternatives. Although not, when you’re sure of the characteristics of your analysis, modifying this type of choice gives Tableau additional info on exactly how to finest configure automated suits throughout studies. Function the fresh new cardinality and you may referential stability possibilities provides Tableau details about how to improve queries.