You could potentially contemplate how study fits together with her and you may what concerns we want to answer, in place of simple tips to blend the info otherwise compensate for artifacts regarding databases.

As an alternative, relationships is the new, versatile way to offer analysis with her away from several provide. The existing tips aren’t going away, and therefore are still useful in certain issues.

• Dating, region step one: Starting the research acting in the Tableau (Hook opens within the a different sort of screen)
• Relationship, region 2: Tricks and tips (Hook opens in the a different window)
• Matchmaking, part step 3: Asking inquiries all over multiple relevant dining tables (Hook up reveals for the an alternate screen)

Fool around with Relationship

This topic guides using strengthening an associated databases and ultizing one for research. If you need to follow along with along, you can install brand new Bookshop studies set (Connect opens up inside a separate window) . Favor Bookshop.xlsx on brutal data to begin with out-of scrape, or MinimalBookshop.tdsx first off the fresh relevant data source rules designed to possess you.

Video: Migrated Investigation

For individuals who discover a current workbook away from an earlier brand of Tableau (variation 2020.1 otherwise prior to) in the Tableau 2020.dos or after, important computer data source loss might show a Moved Studies desk.

You’ll find numerous videos embedded in this material. For your convenience, an excellent transcript is provided on expandable point underneath for each films.

For many who unlock a great workbook made before relationships was available (just before variation 2020.2), your data source might look more. In the event that there are joined otherwise unioned tables, they appear because just one logical dining table named Moved Research. Twice click to see the underlying tables-they truly are nevertheless here, and your analysis commonly still become questioned.

Note that when you’re using only brand new Migrated Analysis dining table, the details pane acts a lot more like earlier incarnations off Tableau Desktop.

Once you’ve extra dating into the investigation design, the details pane position on the new design, with size and you may tips was able in this per dining table, and the Migrated Investigation desk is actually presented just like the just one, blended desk.

Video: Relate tables

charmdate püf noktaları

To construct a repository off related dining tables, connect with your data and you will drag a desk for the canvas. Drag out a second desk. A relationship tend to automatically means whether or not it can. If the Tableau you should never detect the fresh related areas, you happen to be motivated to select him or her oneself.

The fresh canvas you happen to be enjoying is actually an alternative covering of your own studies model where you could relate tables together. Dragging out additional tables contributes these to the information design. The noodle suggests and this tables was relevant.

Relationships is going to be considering computed sphere. It is possible to indicate exactly how fields can be opposed by using workers when you define the partnership.

Include suits

You may make a hop on because of the double hitting a table to start the new join canvas (also referred to as new real covering), following dragging out a table to help make a jump on. Performing meets is the identical sense as the earlier versions off Tableau-you might put a jump on term, plus a formula if required, and arrange the brand new register method of.

Once you close the fresh subscribe canvas, the fresh new desk into the relationships fabric (often referred to as the newest analytical coating) possess a jump on symbol to point the root join. It is because a join merges its tables together to make one, the fresh new dining table. Related tables are nevertheless collection of.

Create unions

Incorporate unions of the dragging-out This new Union. Unions, including satisfies, in reality merge the knowledge, and have a symbol to your analytical layer. We advice usually renaming unions-or one tables with unclear names-so you can anything way more useful.

Video: Performance Alternatives

For any dating, you can find overall performance options including relevant fields. Tableau immediately chooses secure non-payments of these selection. However, if you find yourself clear on the features of one’s investigation, altering these types of selection can give Tableau details on how best to best arrange automated meets during the investigation. Setting the fresh cardinality and you may referential integrity selection offers Tableau considerably more details about how to enhance queries.