You could consider how the data matches together with her and just what inquiries we need to address, in lieu of how-to merge the information and knowledge or compensate for items from the repository.
Instead, matchmaking would be the the fresh new, flexible answer to give research with her out-of multiple source. The present procedures aren’t going away, and are also nevertheless useful in certain issues.
- Relationships, region step one: Initiating the newest study modeling inside the Tableau (Link reveals into the yet another screen)
- Dating, region 2: Tips and tricks (Hook up reveals inside a separate windows)
- Dating, part step three: Asking issues across numerous relevant tables (Hook up reveals from inside the a different sort of windows)
Use Relationships
This subject strolls by way of strengthening a related databases and ultizing one to having research. If you would like to follow along with along, you could down load this new Bookshop research place (Connect opens inside a separate windows) . Like Bookshop.xlsx towards raw research to start off scrape, otherwise MinimalBookshop.tdsx first off the new relevant databases rules designed getting you.
Video: Moved Research
For those who discover a current workbook of a past sorts of Tableau (version 2020.step one otherwise prior to) in the Tableau 2020.2 or later on, your data origin loss you will tell you an excellent Migrated Data table.
You will find several movies stuck within matter. For your convenience, a great transcript is offered regarding expandable part the underside for each video clips.
For folks who discover an effective workbook created before relationships was in fact available (ahead of version 2020.2), important computer data origin might look different. In the event that there are entered or unioned dining tables, they look as a single logical table named Moved Study. Double mouse click observe the root tables-they are hornet giriÅŸ still there, along with your study usually nonetheless work as asked.
Keep in mind that if you find yourself using only the newest Migrated Research table, the info pane acts more like previous versions out of Tableau Desktop.
After you have additional matchmaking toward studies model, the data pane condition towards the design, with dimensions and you will methods maintained within this each desk, together with Migrated Analysis table try showed since one, combined table.
Video: Connect dining tables
To construct a data source out-of associated dining tables, get in touch with your computer data and you may drag a desk into fabric. Drag-out an additional desk. A relationship will instantly mode when it is. In the event that Tableau do not locate the related areas, you will be motivated to select him or her your self.
This new canvas you will be viewing try a special covering of your own analysis model where you can relate tables with her. Dragging out more tables contributes these to the details model. The latest noodle shows and this tables was relevant.
Relationships will be predicated on calculated sphere. It is possible to indicate exactly how industries are opposed that with operators when you establish the partnership.
Incorporate suits
You can create a hop on by double hitting a desk to open up the newest register canvas (also known as the latest physical layer), following dragging-out a table in order to make a join. Doing joins is the identical sense since the previous versions of Tableau-you could lay a hop on clause, including a formula if required, and configure the fresh sign up type of.
When you personal the latest join material, the fresh dining table to your relationship canvas (often referred to as the newest analytical coating) has a join symbol to suggest the root join. Simply because a jump on merges its tables together to create one, the fresh dining table. Associated dining tables continue to be distinctive line of.
Add unions
Add unions by the dragging out The latest Relationship. Unions, particularly suits, actually mix the information, and have an icon toward analytical coating. I encourage constantly renaming unions-otherwise people dining tables that have uncertain brands-so you can one thing a lot more useful.
Video: Overall performance Alternatives
For the relationship, you’ll find overall performance choices together with relevant sphere. Tableau automatically chooses safe non-payments of these options. But not, when you are certain of the advantages of one’s analysis, modifying these selection will offer Tableau facts on the best way to ideal arrange automatic meets throughout analysis. Mode brand new cardinality and referential ethics choice gets Tableau details on exactly how to improve questions.