Play with parameters within the a custom SQL query

You can utilize the next customized SQL ask to get a great trust the number of purchases and you can do a left join to the Sales and you may Providers tables:

Mistakes when backup columns was referenced

In the event the custom SQL query records duplicate articles, you can aquire problems when trying to utilize one of several columns on your data into the Tableau. This can happen even if the ask is valid. For example, consider the following the query:

The fresh query is true, although bien au_id field is confusing as the in this case it can be obtained inside both the “authors” desk plus the “titleauthor” dining table. Tableau usually relate with the fresh query however you will score an mistake whenever you make an effort to make use of the bien au_id career. For the reason that Tableau will not learn hence desk you are it comes down in order to.

Note: It’s a best routine so you’re able to determine column aliases having an enthusiastic Since term whenever you can in a personalized SQL Query. For the reason that for every single database possesses its own guidelines if this involves immediately producing a column identity if in case an enthusiastic alias try perhaps not made use of.

Change a personalized SQL query

1. To your data source web page, on material, double-click the custom SQL query on the analytical covering.
2. Hover along side custom SQL desk about real covering until brand new arrow displays.
3. Click on the arrow after which discover Change Personalized SQL Ask .
4. On dialogue container, revise the new personalized SQL query.

Once you pull a customized SQL ask for the analytical layer of your own fabric, Tableau provides they a default identity: Custom SQL Ask, Customized SQL Query1, and stuff like that. You could potentially replace the standard title so you can things far more meaningful.

With the repository webpage, regarding the logical level of your material, select the miss-down arrow regarding the customized SQL query dining table and select Rename .

You should use parameters within the a customized SQL ask declaration to exchange a constant well worth that have an energetic really worth. You can then revision new parameter on the workbook to change the connection. Like, you could connect with a personalized SQL query giving websites travelers investigation for a specific webpage which is given by a beneficial pageID. In the place of using a constant worth to your pageID worth for the the SQL ask, you might insert a factor. Up coming after completing the connection, you can let you know a parameter handle on the workbook. Use the parameter control to switch from the pageID and you will pull into the research for every web page of great interest without having to revise or copy the connection.

In the Tableau Desktop, you can create a parameter right from the new Personalized SQL dialog box or play with any variables which can be an element of the workbook. For https://datingranking.net/escort-directory/baltimore/ people who carry out a special parameter, it will become readily available for use in the workbook as with any most other parameter. See Would Variables to learn more.

For online currently talking about (when you look at the Tableau On the web otherwise Tableau Server), you need a current parameter published away from Tableau Pc. You can’t manage another type of parameter in online authoring.

1. Towards the data source webpage, throughout the material, hover over the desk up until the edit symbol displays, and click this new edit key.
2. At the end of dialogue container, simply click Input Factor .
3. Discover a steady worth in the SQL report and, in the Submit Factor drop-off selection select the parameter we need to explore instead. When you yourself have perhaps not created a factor yet ,, get a hold of Would a separate factor . Stick to the recommendations for the Carry out Variables which will make a factor.

About example below, new individualized SQL query returns all purchases that will be noted because the Immediate concern. On custom SQL statement, your order top priority ‘s the lingering value. If you wish to alter the connection to see the High priority orders, you would have to revise the info supply.