Dating cannot replace the past ways of consolidating investigation: meets, unions, and you may mixes

Dating cannot replace the past ways of consolidating investigation: meets, unions, and you may mixes

You could potentially remember how research fits together with her and just what questions we would like to respond to, in the place of simple tips to mix the content or compensate for artifacts regarding repository.

Instead, matchmaking certainly are the new, flexible treatment for provide data with her off multiple sources. Current procedures commonly disappearing, and are generally still useful in certain situations.

  • Matchmaking, part step 1: Opening the brand new studies acting from inside the Tableau (Link opens within the a unique windows)
  • Dating, area 2: Tricks and tips (Hook opens from inside the yet another windows)
  • Relationship, part step three: Asking inquiries across the multiple associated tables (Link opens in another screen)

Fool around with Matchmaking

This subject treks using building a related repository and making use of you to definitely to have research. If you like to check out collectively, you can install brand new Bookshop investigation lay (Hook opens inside the a different windows) . Choose Bookshop.xlsx on intense analysis to start out-of scratch, or MinimalBookshop.tdsx in the first place the fresh new related repository principles configured getting you.

Video: Migrated Analysis

For individuals who discover a preexisting workbook away from a previous sort of Tableau (type 2020.step one otherwise earlier) in the Tableau 2020.2 otherwise afterwards, your data provider tab you’ll show an excellent Migrated Study table.

There are numerous movies embedded inside situation. For your benefit, a great transcript is offered regarding expandable section underneath for every videos.

If you open a workbook created before relationship were offered (prior to variation 2020.2), important computer data resource might look additional. In the event the there are entered or unioned tables, they look just like the an individual logical table titled Migrated Data. Double click observe the underlying dining tables-these include nevertheless truth be told there, along with your studies have a tendency to nonetheless work as asked.

Observe that when you are using only the latest Migrated Research desk, the knowledge pane acts more like earlier versions off Tableau Pc.

After you have additional matchmaking into the investigation design, the info pane position into the the brand new build, having size and you may tips handled in this per desk, while the Moved Study desk try demonstrated once the just one, blended desk.

Video: Connect dining tables

To create a repository off associated tables, relate genuinely to your data and you will pull a desk toward material. Drag-out an extra desk. A romance usually immediately means when it can also be. If Tableau don’t locate the relevant sphere, you may be motivated to select them on your own.

This new canvas you may be enjoying try another level of your own studies model where you are able to associate tables along with her. Dragging-out most dining tables contributes these to the details design. The newest noodle shows hence dining tables are relevant.

Relationship are going to be considering computed fields. You may establish how areas shall be compared by using operators when you define the partnership.

Add touches

You may make a join because of the twice hitting a dining table to start the brand new join canvas (also referred to as new real layer), following dragging out a table to create a jump on. Performing suits is similar feel while the earlier incarnations of Tableau-you can set a jump on clause, together with a computation if necessary, and you can arrange the subscribe method of.

After you personal the fresh new sign up fabric, the dining table towards the relationship fabric (also known as the analytical covering) have a join icon to suggest the root sign up. The reason being a join merges their dining tables together to form an individual, brand new desk. Relevant tables are collection of.

Add unions

Add unions of the dragging-out The latest Relationship. Unions, including satisfies, in reality merge the information and knowledge, and show an icon toward logical layer. We advice constantly renaming unions-otherwise one tables with unsure names-so you’re able to some thing a lot more useful.

Video: Show Possibilities

For any matchmaking, you will find show choices including associated fields. Tableau immediately determines secure non-payments of these choice. Yet not, if you find yourself certain of the features of your studies, changing such alternatives offers Tableau much more information on exactly how to most readily useful arrange automatic satisfies throughout research. Setting the latest cardinality and you may referential ethics solutions offers Tableau details on the best way to enhance queries.