You could potentially contemplate how investigation suits together and what concerns we should answer, unlike how to combine the info or make up for artifacts on repository.
Alternatively, matchmaking will be the the new, versatile means to fix offer data with her from several offer. The existing procedures are not disappearing, and tend to be still helpful in specific problems.
- Relationship, region 1: Starting this new research acting in Tableau (Link opens in the a new screen)
- Matchmaking, area 2: Tips and tricks (Hook up reveals inside an alternate windows)
- Relationship, area 3: Inquiring inquiries round the several relevant tables (Connect reveals when you look at the a different screen)
Play with Relationships
This subject walks through building a related data source and ultizing you to definitely for study. If you’d like to adhere to along, you could potentially install new Bookshop data put (Hook opens from inside the a special window) . Like Bookshop.xlsx to the raw study first off off abrasion, otherwise MinimalBookshop.tdsx to begin with this new related databases concepts set up to own you.
Video: Migrated Analysis
For individuals who discover a current workbook from an earlier type of Tableau (type 2020.step 1 otherwise before) in Tableau 2020.2 or after, your data provider loss you will let you know an effective Migrated Studies dining table.
You can find multiple movies inserted contained in this situation. For your convenience, an excellent transcript is offered about expandable area the lower each films.
For those who unlock an excellent workbook created before matchmaking was in fact offered (before adaptation 2020.2), your computer data supply may look some other. In the event the there have been registered or unioned tables, they appear as the a single logical desk called Moved Analysis. Double simply click to see the root dining tables-they’ve been however there, as well as your research will still behave as expected.
Observe that if you are only using new Migrated Analysis table, the content pane acts more like earlier incarnations out of Tableau Pc.
After you’ve additional dating into data design, the data pane status toward the build, with size and actions managed within this for each table, additionally the Moved Studies dining table is showed because the a single, blended dining table.
Video: Connect tables
To create a repository of associated dining tables, connect to your computer data and drag a table on fabric. Drag out a second table https://datingranking.net/tr/chatib-inceleme/. A romance commonly immediately form if this is. If Tableau never locate the brand new associated industries, you will be encouraged to choose them your self.
Brand new material you will be enjoying try another type of coating of data model where you could relate dining tables with her. Dragging-out more dining tables contributes them to the knowledge model. The brand new noodle reveals which tables try related.
Matchmaking is going to be considering calculated industries. It is possible to establish just how areas is going to be opposed by using operators after you describe the partnership.
Add meets
You can create a jump on of the double simply clicking a table to open up the new join material (often referred to as the bodily coating), right after which dragging out a dining table in order to make a hop on. Doing joins is the same feel due to the fact earlier versions out-of Tableau-you could potentially lay a jump on clause, along with a computation if required, and you can configure the fresh subscribe method of.
When you personal the brand new sign-up canvas, brand new dining table toward matchmaking fabric (often referred to as the brand new analytical level) features a join icon to suggest the underlying subscribe. Simply because a join merges their dining tables together to form an individual, the fresh dining table. Related tables will still be distinctive line of.
Incorporate unions
Add unions of the dragging-out The new Commitment. Unions, such joins, actually merge the data, and feature an icon toward analytical layer. I encourage always renaming unions-or one dining tables that have uncertain names-to things much more helpful.
Video: Overall performance Choice
For any dating, there are overall performance solutions as well as associated fields. Tableau automatically determines safe non-payments of these choice. But not, while clear on the features of the investigation, changing such selection will offer Tableau additional info on how best to top arrange automated meets during studies. Function this new cardinality and you may referential integrity options gets Tableau more info on the best way to improve concerns.
