You could potentially contemplate how the investigation suits along with her and you will exactly what questions we should address, rather than tips merge the information and knowledge or compensate for artifacts on the repository.
Rather, relationships may be the the fresh new, versatile cure for offer investigation with her out-of multiple sources. Current actions commonly disappearing, and are generally still helpful in specific problems.
- Dating, part step one: Starting new research acting during the Tableau (Hook up opens up in the a unique windows)
- Dating, region dos: Tips and tricks (Link opens up inside the a new screen)
- Dating, region 3: Asking concerns around the multiple relevant tables (Connect opens inside the a unique windows)
Fool around with Matchmaking
This subject treks using strengthening a connected repository and using you to definitely for research. If you like to adhere to along, you could potentially install the new Bookshop analysis place (Link opens up for the a different sort of windows) . Favor Bookshop.xlsx into the intense research to start regarding abrasion, otherwise MinimalBookshop.tdsx to begin with the latest relevant data source rules designed to possess your.
Video: Migrated Investigation
For many who discover an existing workbook from a previous brand of Tableau (adaptation 2020.step 1 otherwise prior to) from inside the Tableau 2020.dos or later on, important computer data source case you will reveal a Migrated Analysis dining table.
You can find numerous movies embedded inside material. For your convenience, a good transcript exists on the expandable point the underside per video.
For many who unlock a beneficial workbook created before relationship were readily available (ahead of variation 2020.2), your data supply might look other. In the event that there had been entered otherwise unioned dining tables, they look while the an individual logical dining table named Moved Analysis. Twice mouse click observe the underlying dining tables-they’ve been still here, and your research commonly nevertheless work as questioned.
Note that whenever you are only using the brand new Moved Investigation desk, the knowledge pane behaves similar to earlier versions out of Tableau Desktop.
After you have extra matchmaking with the research design, the information and knowledge pane standing to the new style, with proportions and you will strategies handled contained in this for each and every table, in addition to Moved Research dining table try demonstrated just like the an individual, matched dining table.
Video: Relate tables
To build a databases away from relevant dining tables, connect to your computer data and you may pull a dining table with the material. Drag out the next desk. A romance will automatically form whether it is. In the event the Tableau don’t position the brand new relevant sphere, you may be motivated to choose him or her on your own.
This new fabric you’re watching try another type of covering of the study design where you can connect tables with her. Dragging-out most tables contributes these to the information and knowledge model. The newest noodle reveals hence tables is associated.
Relationships is considering calculated sphere. It’s coffee meets bagel gibi uygulamalar also possible to identify just how sphere shall be opposed by using providers after you determine the partnership.
Create touches
You may make a hop on by the twice hitting a dining table to start new sign up material (also called the bodily layer), after which dragging-out a table which will make a join. Undertaking joins is the identical experience given that previous versions of Tableau-you might lay a jump on condition, and additionally a computation if necessary, and arrange this new register style of.
After you personal the sign-up material, this new table with the dating canvas (also called the logical coating) has actually a join icon to indicate the root join. For the reason that a jump on merges its tables along with her to create a single, the desk. Associated tables are line of.
Incorporate unions
Include unions because of the dragging-out The new Connection. Unions, such as for example joins, in reality blend the details, and show an icon to the analytical coating. I encourage constantly renaming unions-otherwise people tables with not sure brands-to help you something even more beneficial.
Video: Performance Options
For all the matchmaking, you can find results selection as well as relevant industries. Tableau automatically decides safe non-payments for those solutions. Yet not, while sure of the features of study, switching this type of solutions will give Tableau additional info for you to greatest arrange automatic touches throughout study. Setting new cardinality and you may referential stability possibilities gets Tableau more info for you to improve concerns.
