Once the database have slightly different SQL sentence structure of each other, the new individualized SQL you employ to hook up to one database you are going to be different about individualized SQL you might use in order to connect to another. Although not, playing with customized SQL can be handy after you know precisely the fresh important information and you can know how to write SQL question.
Although there are a couple of common good reason why you might use personalized SQL, you need to use personalized SQL so you can relationship your computer data across the dining tables, recast fields to execute mix-database satisfies, restructure otherwise reduce the size of important computer data https://www.datingranking.net/escort-directory/cleveland for data, an such like.
Having Excel and you can text document investigation sources, this package can be obtained just during the workbooks that were created before Tableau Desktop 8.2 otherwise while using Tableau Desktop towards Window towards the history commitment. For connecting to Excel otherwise text message records utilizing the legacy union, relate solely to the new file, plus new Unlock dialog box, click the Unlock get rid of-down selection, after which select Open having Heritage Relationship .
NOTE: You start with Tableau 2020.dos, history Excel and Text associations are not any extended supported. Understand the Legacy Commitment Choices file during the Tableau People getting choice to presenting the latest heritage relationship.
Connect with a personalized SQL ask
After you simply click Ok, this new inquire runs and customized SQL ask table looks during the the brand new logical layer of the fabric. Just related fields about customized SQL inquire monitor on study grid on the Databases web page.
Examples of individualized SQL requests
If you wish to append data together, you are able to the fresh new partnership alternative on the actual level regarding the newest fabric into the Tableau. In many cases your databases does not support this option, so you’re able to explore personalized SQL rather.
When you wish to perform a join anywhere between several dining tables within the the new actual level of your own canvas, the content variety of brand new fields your sign up towards have to be a comparable. Inside the cases in the event that analysis type of brand new sphere are not the same, you need custom SQL adjust the data form of (cast) the field just before performing the newest signup.
Such, imagine we would like to signup a couple dining tables, Main and you will Sandwich, with the Supply and ID fields, respectively. The root community try a number style of in addition to ID field was a series type of. You are able to the second personalized SQL inquire to change new analysis style of Means off several so you’re able to a string very that one may get in on the Head and you may Sandwich dining tables utilizing the Supply and you may ID sphere.
When working with massive analysis establishes, often it can save you date while you are working with your computer data in the event the you cure the size very first.
Instance, guess you have an enormous table named FischerIris. You can utilize the second personalized SQL inquire so you can retrieve this new specified articles and details and so reducing the size of the information lay which you relate with off Tableau.
Find [FischerIris].[Species] Since the [Species], [FischerIris].[Width] Because [Petal Width], COUNT([FischerIris].[ID]) Just like the [Num of Species] Of [FischerIris] In which [FischerIris].[Organ] = ‘Petal’ And you can [FischerIris].[Width] > Category Of the [FischerIris].[Species], [FischerIris].[Width]
In some cases, you might be working with a desk that needs to be restructured before investigation. Even though this type of task can help you throughout the bodily covering of your own fabric when you look at the Tableau that with solutions such as for instance rotate, their databases may not back it up. In cases like this, you should use personalized SQL instead.
To evolve the structure and you will optimize your investigation for analysis into the Tableau, you need to use next individualized SQL ask:
Look for Table1.12 months ID Given that [Season ID], Table1.Activities – Don’t like As [Quantity], “Can’t stand” Due to the fact [Reason] Away from Table1 Partnership The Discover Table1.Year ID Since [Year ID], Desk.Items – Faulty While the [Quantity], “Defective” As the [Reason] From Table1 Union All See Table1.Season ID Since [Season ID], Table1.Activities – Too big As the [Quantity], “Too-big” Since the [Reason] Away from Table1 Relationship All Get a hold of Table1.Season ID Due to the fact Year ID, Table1.Factors – Too little Because the [Quantity] “Too little” Because [Reason] Out-of Table1