- BY Luke Johnson
- POSTED IN connexion visitors
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
You might consider the investigation matches together with her and you will just what concerns you want to answer, instead of simple tips http://datingranking.net/tr/connexion-inceleme to merge the information otherwise compensate for items on the data source.
As an alternative, dating will be the the latest, versatile treatment for provide study together with her out-of several supplies. The present procedures commonly disappearing, and are also however useful in particular situations.
- Matchmaking, part step 1: Initiating the brand new research modeling inside the Tableau (Connect opens up into the an alternative windows)
- Relationships, area dos: Tricks and tips (Hook up opens into the an alternate screen)
- Relationship, area step three: Inquiring issues round the several associated dining tables (Hook reveals in the an alternate windows)
Play with Relationships
This subject walks because of building an associated repository and making use of one to to own data. If you like to follow along with collectively, you might obtain new Bookshop investigation put (Hook reveals inside another screen) . Favor Bookshop.xlsx toward intense analysis to start regarding abrasion, otherwise MinimalBookshop.tdsx before everything else the brand new associated data source maxims designed to own you.
Video: Moved Data
For those who unlock a preexisting workbook of an earlier kind of Tableau (type 2020.step 1 otherwise prior to) during the Tableau 2020.2 otherwise later on, your data resource loss you are going to let you know a great Moved Analysis table.
You will find multiple video clips stuck inside procedure. For your convenience, a transcript is offered in the expandable area the underside each video.
If you discover a workbook created before matchmaking had been readily available (before type 2020.2), your computer data source looks more. In the event that there were entered or unioned tables, they look since the an individual analytical desk titled Migrated Research. Twice mouse click to see the root tables-they are however indeed there, as well as your studies will nonetheless work as requested.
Observe that when you are using only the Moved Data dining table, the info pane behaves more like earlier incarnations away from Tableau Pc.
Once you’ve extra relationships for the study design, the content pane reputation into the the design, which have proportions and you will methods handled within this for every dining table, and also the Moved Research desk is actually presented while the a single, combined table.
Video: Connect tables
To build a repository from relevant tables, get in touch with your computer data and you will pull a table to the material. Drag out one minute desk. A relationship usually automatically form if it can. If Tableau don’t locate the fresh new associated sphere, you’re prompted to choose her or him oneself.
The latest fabric you are viewing was a different sort of level of your studies design where you are able to connect dining tables with her. Dragging out a lot more tables adds these to the information and knowledge model. New noodle shows which dining tables is associated.
Matchmaking will likely be according to determined areas. You may indicate how industries should be opposed that with workers once you explain the connection.
Add joins
You may make a jump on because of the double simply clicking a table to open up the latest sign-up canvas (often referred to as the actual coating), following dragging out a desk to make a hop on. Performing matches is the same experience just like the previous versions of Tableau-you could lay a join clause, also a calculation if necessary, and you may configure the new sign up method of.
After you intimate the latest sign up material, the fresh desk on dating fabric (also referred to as the analytical level) has actually a join icon to indicate the root subscribe. The reason being a hop on merges the dining tables along with her to make a single, the latest desk. Related tables will still be collection of.
Include unions
Incorporate unions by the dragging-out The newest Connection. Unions, such as satisfies, indeed merge the details, and show an icon toward analytical level. We advice always renaming unions-or one dining tables with unclear brands-so you’re able to one thing more useful.
Video: Show Alternatives
For the relationship, discover show choice plus relevant fields. Tableau automatically chooses safer non-payments of these possibilities. Although not, if you’re certain of the advantages of research, modifying such solutions gives Tableau more info on how best to better arrange automated joins during the data. Setting the newest cardinality and you can referential integrity selection gives Tableau facts on how best to enhance questions.