You could think about the way the analysis suits together and you will just what issues we wish to address, unlike simple tips to blend the details otherwise compensate for artifacts in the data source.
Instead, matchmaking may be the new, flexible solution to render studies together with her out of numerous present. Current tips aren’t going away, and so are nevertheless useful in specific conditions.
- Dating, area step one: Opening this new investigation modeling into the Tableau (Connect opens inside a new screen)
- Matchmaking, region dos: Tips and tricks (Link opens in a unique screen)
- Relationships, region step 3: Inquiring issues all over several relevant tables (Link opens up in another window)
Fool around with Relationships
This topic treks through strengthening a connected data source and ultizing you to definitely for study. If you would like to follow collectively, you can download the fresh Bookshop data place (Connect reveals into the a different screen) . Choose Bookshop.xlsx into the raw study to start from scrape, otherwise MinimalBookshop.tdsx to begin with this new related repository axioms set up to own you.
Video: Migrated Data
For folks who unlock an existing workbook regarding a previous form of Tableau (type 2020.step one otherwise prior to) during the Tableau 2020.2 or after, your computer data origin tab you are going to show an effective Migrated Investigation desk.
You can find multiple video inserted within topic. For your convenience, a great transcript is provided throughout the expandable area underneath for every single movies.
For people who unlock a great workbook created before relationships have been available (just before version 2020.2), your computer data source might look some other. If there were entered otherwise unioned tables, they appear just like the an individual logical desk named Migrated Investigation. Twice mouse click observe the underlying dining tables-they are nonetheless there, as well as your study commonly still work as expected.
Note that if you are only using the Migrated Research dining table, the content pane behaves a lot more like earlier versions out-of Tableau Desktop large friends ne iÅŸe yarar.
After you’ve additional dating with the investigation model, the info pane position into the fresh new concept, that have proportions and you may actions managed inside for every table, therefore the Moved Studies desk are presented due to the fact one, blended desk.
Video: Relate tables
To create a databases regarding relevant dining tables, relate with important computer data and you may pull a desk with the fabric. Drag-out one minute dining table. A romance usually instantly setting when it is. In the event that Tableau usually do not position the brand new related sphere, you will be caused to select them on your own.
The fresh canvas you are seeing is yet another coating of data design where you can associate tables together with her. Dragging-out most tables adds these to the information design. The noodle suggests and that tables try associated.
Relationships will be based on computed industries. You can establish how areas would be opposed that with providers once you identify the connection.
Put suits
You may make a jump on by twice hitting a dining table to start the brand new sign-up material (also referred to as brand new real level), following dragging out a table which will make a join. Creating satisfies is similar experience since the earlier versions out-of Tableau-you could potentially lay a hop on clause, as well as a calculation if required, and you will arrange the fresh signup sort of.
When you close the latest signup material, new desk into matchmaking material (also referred to as the new logical covering) keeps a join icon to suggest the root subscribe. Simply because a hop on merges its tables along with her to make just one, the brand new desk. Associated tables continue to be distinct.
Put unions
Create unions from the dragging out The fresh new Partnership. Unions, such as for instance joins, indeed merge the content, and have an icon towards analytical coating. I encourage always renaming unions-otherwise people tables which have not sure names-to some thing a lot more of good use.
Video: Overall performance Possibilities
For relationships, you will find results options including related areas. Tableau immediately chooses safer non-payments of these alternatives. Although not, if you find yourself sure of the features of your own studies, switching these alternatives will offer Tableau more information for you to better configure automated matches during the studies. Function the newest cardinality and you may referential integrity choices gets Tableau additional information about how to optimize inquiries.
