Matchmaking cannot change the previous ways of merging analysis: touches, unions, and you may blends

You could potentially think about the way the investigation matches along with her and you can just what inquiries you want to respond to, as opposed to just how to mix the info otherwise compensate for artifacts about repository.

Instead, relationship will be the fresh, flexible treatment for bring studies with her regarding several supply. The current steps aren’t disappearing, and tend to be nonetheless useful in specific situations.

  • Relationships, region 1: Introducing new research acting from inside the Tableau (Connect reveals inside a different windows)
  • Relationship, part 2: Tricks and tips (Hook opens into the an alternative windows)
  • Dating, area step three: Inquiring issues across the numerous relevant tables (Link reveals into the a unique window)

Use Dating

This topic walks because of strengthening a related data source and using you to to own studies. If you want to follow collectively, you might download the latest Bookshop studies set (Connect opens from inside the yet another screen) . Prefer Bookshop.xlsx for the brutal research to start away from scrape, otherwise MinimalBookshop.tdsx in the first place this new relevant databases basics designed to possess your.

Video: Moved Data

If you unlock a preexisting workbook away from a past types of Tableau (variation 2020.step one or prior to) into the Tableau 2020.2 or later on, your computer data provider tab might reveal a good Migrated Studies desk.

There are numerous video inserted within this issue. For your convenience, a transcript is offered in the expandable point the lower per video clips.

For folks who open a workbook made before relationships were available (in advance of adaptation 2020.2), your computer data resource looks different. In the event the there are registered otherwise unioned dining tables, they appear given that just one logical table titled Migrated Data. Twice mouse click observe the root tables-they might be nevertheless here, as well as your investigation often nonetheless become questioned.

Observe that when you’re using only the brand new Moved Analysis desk, the content pane acts more like previous versions out-of Tableau Desktop.

After you’ve additional dating towards study model, the details pane position with the the newest build, that have proportions and procedures managed within this for every single table, and Migrated Investigation desk is actually showed since the an individual, blended table.

Video: Relate tables

To build a databases regarding related dining tables, connect with important computer data and pull a dining table on the material. Drag-out the second table. A relationship commonly automatically form if this can also be. In the event the Tableau never detect this new relevant industries, you happen to be prompted to choose him or her your self.

Brand new material you might be seeing is a special coating of analysis design where you could relate dining tables together with her. Dragging-out even more dining tables adds these to the information design. The new noodle suggests and that tables are associated.

Matchmaking is going to be based on computed fields. You’ll be able to specify exactly how fields is going to be compared by using operators once you identify the relationship.

Include joins

You can create a jump on because of the twice clicking on a dining table to open up the fresh new join fabric (often referred to as new bodily coating), then dragging out a desk which will make a jump on. Doing satisfies is the same experience since the previous versions of Tableau-you can put a join term, including a formula if necessary, and you can configure this new join types of.

After you close the new sign-up canvas, new table towards matchmaking material (referred to as brand new analytical layer) keeps a hop on icon to point the underlying signup. Simply because a hop on merges their tables along with her in order to create just one, the new table. Related tables will still be collection of.

Add unions

Include unions of the dragging out The latest Commitment. Unions, eg matches, in reality combine the info, and show a symbol on the logical layer. We recommend constantly renaming unions-otherwise one tables with unclear names-so you’re able to something even more of good use.

Video: Performance Choices

When it comes to relationships, there are performance options together with relevant sphere. Tableau immediately chooses secure non-payments for these choice. But not, while you are clear on the characteristics of your data, changing these solutions will offer Tableau much more information chatki help on exactly how to top arrange automatic satisfies while in the research. Function this new cardinality and referential ethics choice brings Tableau more info for you to optimize concerns.


No responses yet