You could think about how studies suits with her and you can what questions we wish to address, in place of just how to mix the knowledge otherwise compensate for items from the databases.

Instead, relationships certainly are the the fresh new, versatile means to fix provide research together from several present. Current measures aren’t disappearing, and are usually still helpful in specific conditions.

• Relationships, part step 1: Initiating the newest analysis acting inside the Tableau (Hook opens into the yet another window)
• Dating, region dos: Tricks and tips (Hook reveals during the yet another window)
• Matchmaking, part step 3: Inquiring issues round the numerous relevant dining tables (Link opens up within the a unique window)

Have fun with Relationships

This subject treks compliment of strengthening an associated databases and utilizing one to own studies. If you would like to follow collectively, you could install the latest Bookshop analysis put (Hook up opens into the another type of windows) . Like Bookshop.xlsx to your intense data first off regarding scratch, otherwise MinimalBookshop.tdsx to begin with the new relevant databases maxims set up to have you.

Video: Moved Data

For individuals who unlock a preexisting workbook away from an earlier style of Tableau (variation 2020.step one otherwise earlier) inside the Tableau 2020.2 otherwise after, your data provider loss you are going to tell you a Migrated Data desk.

You will find multiple movies stuck inside matter. For your benefit, a transcript is offered about expandable point the lower for every clips.

For those who open an excellent workbook made before relationships had been offered (before adaptation 2020.2), your computer data provider might look more. In the event the there have been entered or unioned dining tables, they look as an individual analytical desk named Moved Study. Double click to see the root dining tables-these are generally nevertheless around, as well as your research commonly still behave as expected.

Note that if you’re only using new Moved Investigation table, the knowledge pane behaves more like earlier incarnations away from Tableau Pc.

Once you’ve added matchmaking towards the analysis model, the data pane position to your the brand new build, with dimensions and measures managed within this for every dining table, in addition to Migrated Analysis dining table try presented once the just one, blended desk.

Video: Connect tables

To create a databases of related dining tables, get in touch with your data and you can pull a desk toward material. Drag-out a second table. A love usually automatically setting in the event it can. In the event that Tableau never position the new associated sphere, you’re caused to choose them on your own.

The fresh canvas you will be watching was a unique level of the research model where you can relate dining tables along with her. Dragging out extra dining tables contributes them to the information design. The new noodle suggests hence dining tables was related.

Dating is going to be predicated on determined sphere. You may establish just how areas might be compared that with workers once you describe the partnership.

Put touches

You may make a join because of the twice simply clicking a desk to open the brand new sign-up material (also called new real level), right after which dragging-out a table to create a jump on. Carrying out joins is the identical sense while the previous versions from Tableau-you might lay a hop on clause, also a computation if required, and you can arrange the newest sign-up types of.

When you close the latest sign up material, the new table toward relationship fabric (also referred to as the newest logical coating) enjoys a jump on icon to point the root sign up. This is because a hop on merges the dining tables along with her to create just one, brand new table. Relevant tables are collection of.

Include unions

Put unions by dragging-out The latest Commitment. Unions, such as for instance meets, indeed mix the data, and show an icon with the analytical covering. We advice constantly renaming unions-or any dining tables with undecided labels-in order to one thing even more useful.

Video: Efficiency Solutions

Your dating, you’ll find overall performance options also relevant sphere. Tableau instantly chooses safe defaults of these choice. Yet not, if you are certain of the advantages of your own research, modifying such options gives Tableau considerably more details on the best way to most useful configure automatic meets through the analysis. Means the new cardinality and you can referential integrity selection brings Tableau details about how farmersonly promosyon kodu to optimize inquiries.