You can think about how research matches together and you may what concerns you want to respond to, rather than ideas on how to blend the content otherwise compensate for items on the data source.
Rather, relationship are the the fresh new, versatile answer to provide study along with her off numerous supply. The current steps aren’t going away, and generally are nonetheless useful in particular circumstances.
- Relationships, area 1: Releasing this new study modeling within the Tableau (Hook opens up when you look at the a new window)
- Matchmaking, area 2: Tricks and tips (Connect reveals inside the another type of screen)
- Relationships, part step 3: Asking concerns across several relevant dining tables (Connect reveals for the a new windows)
Fool around with Relationships
This subject strolls owing to building www.datingranking.net/tr/chinalovecupid-inceleme a related databases and making use of that to have research. If you prefer to check out collectively, you can install the brand new Bookshop research set (Connect reveals for the a unique window) . Like Bookshop.xlsx into intense analysis to start of abrasion, otherwise MinimalBookshop.tdsx in the first place the fresh relevant repository rules set up for your.
Video: Migrated Analysis
If you discover an existing workbook out of an earlier style of Tableau (version 2020.step 1 or earlier) inside the Tableau 2020.2 or later, important computer data supply tab you are going to tell you a beneficial Moved Study desk.
You can find several movies stuck within situation. For your convenience, a beneficial transcript emerges throughout the expandable point the underside per clips.
If you discover an excellent workbook made before matchmaking had been available (just before variation 2020.2), your data origin may look other. If there are inserted or unioned dining tables, they appear since an individual logical dining table named Moved Study. Twice mouse click observe the root tables-they truly are still indeed there, plus studies commonly however act as questioned.
Note that if you’re only using brand new Migrated Study desk, the content pane behaves similar to previous versions out of Tableau Desktop.
Once you have added relationships for the study design, the info pane status on this new build, having dimensions and methods was able contained in this for every single dining table, while the Moved Investigation dining table are presented as one, matched table.
Video: Associate tables
To construct a data source off related tables, connect to your computer data and you will pull a dining table for the fabric. Drag out another dining table. A love usually immediately means whether it is also. When the Tableau dont choose new associated industries, you’re encouraged to choose her or him on your own.
New fabric you’re enjoying was an alternate coating of your own study model where you can connect tables together. Dragging out extra dining tables adds these to the information model. New noodle suggests hence dining tables was associated.
Matchmaking is going to be according to determined fields. You can even indicate exactly how areas should be opposed by using providers after you define the partnership.
You can create a jump on of the double hitting a desk to start this new subscribe fabric (often referred to as this new bodily layer), right after which dragging-out a dining table to help make a jump on. Starting touches is similar feel because the earlier incarnations off Tableau-you might place a jump on condition, along with a formula if necessary, and you may arrange new subscribe particular.
Once you romantic the register material, brand new dining table to the relationships material (also referred to as the new analytical coating) possess a hop on icon to indicate the underlying sign-up. This is because a join merges the tables together with her to make a single, the new table. Relevant tables continue to be line of.
Put unions because of the dragging out The fresh Union. Unions, such satisfies, indeed mix the information and knowledge, and show an icon to your logical layer. I encourage always renaming unions-otherwise people dining tables with undecided names-so you’re able to some thing far more of good use.
Video: Abilities Selection
When it comes down to relationship, you will find show alternatives and additionally associated sphere. Tableau immediately chooses safer defaults of these choice. However, when you are sure of the features of one’s data, changing these solutions will offer Tableau more details for you to most useful configure automatic matches while in the investigation. Form the cardinality and you can referential stability solutions provides Tableau info on the best way to improve questions.