You can remember how the research matches together with her and just what concerns we would like to respond to, in place of how to mix the knowledge otherwise make up for items regarding the data source.
Rather, matchmaking are definitely the this new, versatile answer to bring data together of numerous source. The current measures commonly disappearing, and are usually still helpful in particular circumstances.
- Matchmaking, part step 1: Releasing the fresh investigation acting in Tableau (Hook reveals when you look at the an alternate window)
- Dating, part 2: Tricks and tips (Link reveals into the a different window)
- Dating, part 3: Inquiring questions around the numerous relevant dining tables (Link opens during the a separate screen)
Explore Matchmaking
This subject strolls courtesy building a related repository and using one to getting studies. If you would like to check out collectively, you could potentially install the Bookshop analysis set (Link reveals into the a separate window) . Favor Bookshop.xlsx into brutal studies to start out-of abrasion, or MinimalBookshop.tdsx to begin with the newest associated repository axioms set up getting you.
Video: Migrated Analysis
For individuals who discover a current workbook regarding a previous style of Tableau (version 2020.step one or prior to) in the Tableau 2020.2 or later, your computer data origin tab you are going to reveal a great Migrated Analysis table.
You will find multiple video stuck contained in this procedure. For your benefit, good transcript is provided regarding the expandable section the underside for each video.
For those who open a workbook created before dating was indeed readily available (before version 2020.2), your data supply may look some other. If there have been joined otherwise unioned tables, they appear because a single logical dining table entitled Migrated Analysis. Twice click to see the root tables-they truly are nonetheless around, and your data often however act as requested.
Remember that if you’re using only the fresh Moved Analysis desk, the data pane behaves more like previous versions regarding Tableau Desktop computer.
Once you’ve additional relationships on data design, the details pane updates towards brand new layout, that have dimensions and strategies handled within this for every desk, and also the Migrated Data table try shown as the an individual, combined dining table.
Video: Connect tables
To build a data source of relevant tables, get in touch with your data and you will pull a desk into canvas. Drag-out the second table. A romance commonly immediately form if it normally. If the Tableau dont locate the related fields, you happen to be encouraged to select her or him your self.
This new fabric you might be enjoying was yet another layer of your investigation design where you could connect dining tables together. Dragging out most tables contributes these to the info model. The noodle shows and that dining tables try relevant.
Dating are going to be considering determined fields. You may want to identify just how sphere will be opposed that with workers when you explain the partnership.
Add suits
You can create a hop on by the double clicking on a desk to open up the sign up material (referred to as brand new bodily covering), and dragging out a dining table to help make a hop on. Performing satisfies is the identical sense since the earlier incarnations out-of Tableau-you could potentially place a jump on condition, plus a calculation if necessary, and you will configure brand new signup type.
When you intimate this new join material, this new dining table with the relationships fabric (often referred to as this new logical covering) provides a join icon to suggest the root sign-up. The reason being a jump on merges the tables along with her to create one, new desk. Related dining tables are nevertheless line of.
Put unions
Add unions from the dragging-out The brand new Relationship. Unions, for example suits, in fact blend the information, and show a symbol for the logical covering. We advice always renaming unions-or any tables that have unsure names-to anything even more helpful.
Video: Show Options
For any relationships, you will find results selection and additionally relevant sphere. Tableau automatically determines safe defaults for these choice. However, if you good grief kaydol find yourself sure of the features of your own data, modifying this type of choice will give Tableau facts on precisely how to most readily useful configure automatic suits throughout data. Form the new cardinality and referential stability possibilities gives Tableau more info on how best to improve question.