You can consider how study fits together with her and you will just what issues you want to address, in place of how-to blend the details otherwise make up for items on repository.
Alternatively, matchmaking certainly are the the brand https://datingranking.net/tr/established-men-inceleme/ new, versatile answer to bring studies with her away from numerous present. Current strategies are not disappearing, and they are nevertheless useful in specific circumstances.
- Dating, region 1: Launching the fresh data acting into the Tableau (Hook up opens up from inside the another windows)
- Relationships, part 2: Tips and tricks (Link opens for the a unique windows)
- Relationship, part step 3: Inquiring questions around the multiple associated dining tables (Hook reveals within the an alternative windows)
Use Dating
This topic treks by way of building a connected data source and making use of one to getting research. If you prefer to follow with each other, you can download new Bookshop research lay (Hook reveals when you look at the a special windows) . Choose Bookshop.xlsx with the brutal study to start regarding scrape, or MinimalBookshop.tdsx first off new associated repository axioms designed to own you.
Video: Moved Study
For people who discover an existing workbook from a previous sorts of Tableau (version 2020.1 otherwise before) within the Tableau 2020.2 or later, important computer data source tab you will let you know a beneficial Moved Studies table.
Discover multiple movies stuck inside topic. For your convenience, a transcript exists about expandable point the underside each video.
For many who open a great workbook made before dating were readily available (prior to type 2020.2), your computer data origin looks different. In the event the there were entered or unioned tables, they appear given that a single analytical dining table named Moved Studies. Twice mouse click to see the root tables-they truly are still here, along with your data tend to nonetheless work as requested.
Note that whenever you are using only brand new Migrated Studies table, the information and knowledge pane acts similar to earlier incarnations of Tableau Desktop.
Once you have additional relationship toward study design, the knowledge pane standing into the new concept, that have dimensions and actions handled in this for each desk, therefore the Migrated Analysis table was presented because just one, blended desk.
Video: Connect tables
To build a repository off relevant tables, interact with your data and you may pull a desk on material. Drag out an additional dining table. A relationship tend to automatically function when it can. In the event the Tableau try not to select the fresh new related areas, you may be encouraged to select him or her your self.
The fresh new canvas you will be watching was a separate layer of one’s data model where you could associate dining tables together. Dragging out extra dining tables contributes these to the data model. The latest noodle shows hence tables was associated.
Dating is based on computed industries. You can even identify just how areas are going to be compared by using operators after you describe the connection.
Include joins
You possibly can make a jump on by double simply clicking a table to start the brand new signup material (often referred to as this new real layer), and then dragging out a dining table to help make a join. Undertaking suits is the same sense since previous versions out of Tableau-you could place a hop on clause, along with a formula if necessary, and you can arrange this new signup type.
Once you intimate the newest sign-up fabric, brand new desk to the relationships material (referred to as the analytical coating) keeps a join icon to point the underlying sign up. The reason being a join merges its dining tables along with her to make one, brand new desk. Relevant tables are nevertheless distinct.
Put unions
Put unions by dragging out New Union. Unions, such as meets, actually combine the data, and show a symbol for the logical layer. We recommend always renaming unions-or any dining tables that have undecided labels-to help you something alot more beneficial.
Video: Results Solutions
Your relationship, you will find overall performance possibilities and additionally related areas. Tableau instantly determines safe defaults for those possibilities. not, if you’re clear on the characteristics of your own studies, changing this type of possibilities deliver Tableau additional info on precisely how to top arrange automated suits during analysis. Setting the cardinality and referential ethics alternatives provides Tableau additional info on the best way to optimize concerns.