Relationship dont replace the early in the day way of merging study: touches, unions, and combines

You could potentially contemplate the way the analysis fits along with her and just what issues we wish to answer, instead of simple tips to blend the information and knowledge or compensate for items regarding the databases.

Alternatively, matchmaking may be the the new, flexible means to fix bring investigation along with her of numerous offer. Current tips commonly going away, and they are however useful in certain situations.

• Relationships, region 1: Opening brand new study modeling into the Tableau (Hook opens up in another type of screen)
• Relationships, area 2: Tricks and tips (Hook up opens up from inside the another type of window)
• Dating, area 3: Asking issues across the several relevant tables (Link opens inside the a different sort of screen)

Have fun with Dating

This subject treks as a consequence of strengthening a related data source and using you to to own data. If you want to follow along with together, you might down load the Bookshop studies place (Connect opens in the a different sort of windows) . Prefer Bookshop.xlsx for the intense investigation to begin with off scratch, or MinimalBookshop.tdsx in the first place this new relevant databases rules designed getting you.

Video: Moved Studies

For people who discover a preexisting workbook from a previous sorts of Tableau (adaptation 2020.1 otherwise earlier) in the Tableau 2020.dos or later, important computer data source tab you will reveal a good Moved Study desk.

You’ll find numerous films embedded within matter. For your convenience, a beneficial transcript is offered from the expandable section the underside per videos.

For people who discover a good workbook created before relationships was in fact offered (prior to version 2020.2), your data provider looks additional. If the there have been inserted otherwise unioned dining tables, they look because a single analytical desk entitled Moved Studies. Double mouse click observe the root tables-they might be still around, as well as your study have a tendency to still act as requested.

Keep in mind that while only using the latest Migrated Studies dining table, the data pane behaves more like previous versions from Tableau Pc.

Once you Bu bağlantıyı şimdi hemen kontrol edin have added relationship towards study design, the content pane status to the the newest design, having proportions and you may procedures handled contained in this for each desk, therefore the Moved Analysis desk are showed because a single, matched desk.

Video: Associate dining tables

To construct a data source out of relevant dining tables, connect to important computer data and you can drag a desk with the material. Drag out the next desk. A love tend to instantly setting if this is. In the event that Tableau dont place the latest associated areas, you happen to be prompted to choose them on your own.

The fabric you will be enjoying was an alternate coating of the research design where you can associate tables together. Dragging out more tables contributes them to the knowledge design. This new noodle shows and this dining tables are related.

Relationship are going to be according to calculated industries. You may establish exactly how areas should be compared that with operators once you describe the connection.

Create joins

You possibly can make a jump on by twice hitting a desk to open the fresh new subscribe material (also known as the brand new physical level), then dragging-out a table to make a join. Creating satisfies is similar feel once the previous versions out of Tableau-you can place a join term, as well as a calculation if necessary, and configure this new subscribe type.

Once you romantic the brand new subscribe canvas, the new dining table towards matchmaking fabric (also called the latest logical covering) keeps a hop on icon to suggest the root sign-up. It is because a hop on merges its tables together with her to make an individual, brand new dining table. Related tables are nevertheless type of.

Put unions

Create unions of the dragging-out Brand new Connection. Unions, for example meets, in fact merge the content, and feature an icon toward analytical level. I encourage usually renaming unions-or people dining tables having unsure labels-in order to things a great deal more helpful.

Video: Abilities Alternatives

For any relationship, you’ll find efficiency options together with relevant industries. Tableau automatically chooses secure non-payments for these possibilities. Although not, if you are sure of the features of one’s analysis, changing this type of choice offers Tableau much more information on the best way to most readily useful arrange automatic meets during data. Function the latest cardinality and you may referential stability solutions gives Tableau addiitional information on how best to enhance issues.