Relationships try not to change the prior ways of combining investigation: meets, unions, and you will blends

You might remember the way the study matches with her and what concerns we should respond to, instead of ideas on how to mix the info otherwise make up for items about repository.

Instead, relationship certainly are the the, versatile means to fix bring research along with her of several present. Current procedures are not going away, and generally are however useful in particular conditions.

  • Relationship, region step one: Introducing the fresh study modeling when you look at the Tableau (Connect opens up during the a new screen)
  • Dating, region 2: Tricks and tips (Link opens inside the a special windows)
  • Matchmaking, area 3: Asking inquiries round the multiple associated tables (Connect opens up inside an alternate screen)

Play with Relationships

This topic treks because of building a connected databases and making use of one to to possess investigation. If you like to follow along with with each other, you might obtain the fresh Bookshop studies place (Connect reveals inside yet another screen) . Favor Bookshop.xlsx on raw data to begin with out-of scratch, or MinimalBookshop.tdsx before everything else new relevant repository principles set up to own you.

Video: Migrated Research

If you unlock a preexisting workbook off a past type of Tableau (version 2020.step 1 otherwise earlier) within the Tableau 2020.dos otherwise later on, your computer data origin loss you will show good Migrated Analysis table.

Discover multiple films stuck contained in this situation. For your convenience, a great transcript emerges on the expandable part the underside each video.

If you unlock a workbook created before dating was indeed offered (before variation 2020.2), your data origin might look various other. When the there were joined otherwise unioned dining tables, they appear once the a single logical dining table titled Migrated Analysis. Double mouse click observe the underlying dining tables-they have been nonetheless around, as well as your research often nevertheless become requested.

Observe that when you find yourself using only the latest Migrated Analysis dining table, the information and knowledge pane acts similar to previous versions out of Tableau Desktop computer.

After you’ve additional relationships into the investigation design, the knowledge pane condition to your the fresh new build, which have size and you may methods managed within this for each dining table, as well as the Migrated Study desk is exhibited once the an individual, merged desk.

Video: Relate dining tables

To create a repository out-of relevant tables, get in touch with your computer data and you can drag a dining table to your canvas. Drag out the next table. A romance will automatically means whether or not it can. If Tableau try not to find the fresh new related areas, you may be motivated to select them on your own.

Brand new fabric you may be seeing is actually yet another level of your own analysis model where you could relate dining tables together with her. Dragging out a lot more tables contributes these to the knowledge design. The latest noodle suggests hence dining tables try related.

Dating should be centered on determined sphere. You may want to indicate how areas would be compared by using workers once you determine the relationship.

Put satisfies

You may make a hop on by the double clicking on a ek kaynaklar dining table to start the newest subscribe canvas (also called the fresh new real coating), immediately after which dragging-out a table in order to make a join. Carrying out touches is similar feel as the previous versions off Tableau-you can set a join term, together with a computation if necessary, and you may arrange the new sign up type.

Once you romantic the new sign up fabric, the fresh dining table on the matchmaking canvas (also known as the fresh logical coating) provides a hop on icon to point the underlying sign up. The reason being a hop on merges their dining tables together with her in order to create an individual, brand new table. Associated dining tables are distinct.

Put unions

Incorporate unions by the dragging out The Relationship. Unions, eg matches, actually combine the info, and show an icon on logical layer. I encourage always renaming unions-or people tables that have unsure brands-to anything a whole lot more of use.

Video: Show Selection

For any relationship, you will find show selection including related industries. Tableau instantly chooses safe non-payments for those choice. But not, whenever you are sure of the advantages of your own data, altering these choice deliver Tableau additional information on precisely how to ideal arrange automatic meets while in the investigation. Function the fresh cardinality and you will referential integrity alternatives offers Tableau info about how to optimize issues.


Leave a Reply

Your email address will not be published. Required fields are marked *

Open chat