Have fun with parameters for the a personalized SQL ask
You should use the next individualized SQL query discover a great trust what amount of instructions and you can perform a left https://datingranking.net/escort-directory/austin/ join for the Sales and you may Companies dining tables:
Mistakes whenever content articles are referenced
In case the customized SQL query records duplicate articles, you may get errors when trying to utilize one of the articles on your studies for the Tableau. This may happen even if the ask holds true. Such as for instance, think about the following query:
The latest ask is true, nevertheless au_id profession is confusing while the in cases like this they can be obtained during the both “authors” dining table and also the “titleauthor” desk. Tableau commonly relate with the fresh ask but you will score an error anytime you you will need to make use of the bien au_id industry. Simply because Tableau doesn’t know and that desk you’re it comes in order to.
Note: It’s a best practice in order to identify line aliases that have a keen As the term whenever you can within the a personalized SQL Query. Simply because for each databases has its own laws if this relates to immediately producing a line title whenever an enthusiastic alias is not utilized.
Edit a custom made SQL query
- Toward databases web page, regarding the fabric, double-click on the individualized SQL query about analytical layer.
- Hover over the individualized SQL dining table on the actual covering up to the new arrow displays.
- Click on the arrow right after which see Modify Personalized SQL Query .
- In the dialog box, revise this new individualized SQL query.
After you pull a customized SQL inquire into analytical covering of your own material, Tableau gets it a default title: Individualized SQL Inquire, Customized SQL Query1, and stuff like that. You can change the default identity to anything far more meaningful.
On the databases web page, regarding the logical layer of your own material, discover lose-down arrow on individualized SQL ask table and choose Rename .
You need to use details inside the a custom SQL ask statement to help you exchange a stable really worth which have a dynamic value. After that you can posting the brand new parameter from the workbook to modify the partnership. Including, you may also connect to a custom made SQL query giving internet traffic analysis getting a certain page which is given from the good pageID. Unlike playing with a constant worthy of to the pageID worthy of when you look at the the newest SQL inquire, you could insert a factor. Next shortly after finishing the partnership, you might let you know a factor manage regarding workbook. Make use of the parameter control to alter out the pageID and eliminate inside the investigation per web page interesting without the need to change or duplicate the connection.
Into the Tableau Desktop computer, you may make a factor directly from this new Individualized SQL dialog box otherwise have fun with one variables which can be a portion of the workbook. If you do an alternate factor, it becomes designed for include in brand new workbook just like any almost every other parameter. See Carry out Details to learn more.
To have net authoring (inside the Tableau On the internet or Tableau Server), you are able to a current factor published regarding Tableau Pc. You simply cannot perform a different factor when you look at the websites authoring.
- For the repository web page, on the material, hover over the desk till the revise symbol screens, and then click the latest modify key.
- At the bottom of your own dialog box, mouse click Enter Factor .
- Come across a constant worthy of about SQL statement right after which, on the Type Parameter shed-down eating plan discover parameter we need to fool around with alternatively. When you yourself have maybe not created a factor yet ,, pick Carry out another parameter . Follow the instructions inside Carry out Details to produce a parameter.
Regarding example below, the brand new custom SQL inquire production most of the orders that are designated given that Urgent top priority. Regarding individualized SQL statement, the transaction concern is the constant worthy of. If you wish to change the connection to comprehend the Highest consideration instructions, you would need to change the content origin.