You could potentially consider how studies matches together with her and you will what inquiries we should address, in place of how to merge the content otherwise make up for artifacts about databases.
Alternatively, relationships certainly are the the fresh new, flexible cure for provide investigation with her from numerous supplies. The existing procedures are not going away, and tend to be however helpful in certain situations.
- Dating, region step one: Opening this new investigation acting for the Tableau (Connect opens up into the another type of windows)
- Relationship, region 2: Tricks and tips (Link opens up in another window)
- Relationships, part step 3: Inquiring inquiries around the numerous related tables (Hook opens up inside a new window)
Play with Relationship
This topic guides thanks to strengthening an associated data source and using one to getting data. If you want to check out together, you might down load the new Bookshop studies lay (Hook up opens up from inside the a separate screen) . Choose Bookshop.xlsx toward intense analysis to start out of abrasion, or MinimalBookshop.tdsx first off the latest relevant repository basics designed to possess you.
Video: Migrated Investigation
For people who discover a preexisting workbook out-of a previous brand of Tableau (variation 2020.step one or earlier) within the Tableau 2020.2 otherwise afterwards, important computer data supply loss might tell you a Migrated Investigation desk.
You’ll find multiple videos embedded in this point. For your convenience, an excellent transcript is offered in the expandable point the underside for every single video clips.
For many who open a beneficial workbook created before relationship was indeed readily available (prior to version 2020.2), your computer data supply looks additional. If the there have been registered otherwise unioned tables, they look because one logical table entitled Migrated Studies. Double click to see the root tables-these are generally still around, plus study often nonetheless behave as questioned.
Remember that when you find yourself using only the fresh new Migrated Investigation desk, the knowledge pane acts more like earlier versions off Tableau Pc.
After you have added matchmaking into the study design, the content pane position into the build, which have proportions and you may procedures managed in this per desk, while the Migrated Studies desk try presented since a single, combined table.
Video: Associate dining tables
To build a databases regarding relevant dining tables, relate solely to important computer data and drag a dining table for the canvas. Drag-out the second table. A love have a tendency to automatically function whether or not it can be. In the event that Tableau do not select this new associated areas, you will be encouraged to choose her or him your self.
The fresh material you’re enjoying was yet another covering of your investigation design where you could relate dining tables along with her. Dragging-out most dining tables adds these to the information design. The fresh new noodle shows and this tables is related.
Dating shall be based on calculated areas. You could specify exactly how industries is going to be opposed that with providers after you determine the connection.
You possibly can make a join by the double simply clicking a table to start new register canvas (often referred to as the fresh new real level), right after which dragging-out a dining table in order to make a jump on. Undertaking joins is similar sense just like the earlier versions off Tableau-you could set a join condition, together with a formula if required, and you can arrange the brand new signup type.
Once you romantic the fresh new signup fabric, brand new dining table to your relationship canvas (also referred to as this new analytical coating) enjoys a jump on symbol to indicate the underlying join. It is because a jump on merges its dining tables together in order to create an individual, brand new dining table. Relevant tables are line of.
Incorporate unions by the dragging out The Union. Unions, such as for example meets, in reality merge the information, and feature an icon on the logical level. We advice always renaming unions-otherwise people dining tables with unclear labels-to help you something alot more helpful.
Video: Abilities Possibilities
For all the matchmaking, you can find abilities selection plus associated fields. Tableau immediately chooses safe defaults for those choice. not, when you find yourself certain of the advantages of your own analysis, switching these possibilities deliver Tableau more details on how best to greatest configure automated joins during analysis. Function the fresh new cardinality and you may referential integrity choice offers Tableau considerably more details about how to improve queries.
Leave a reply