Explore variables during the a personalized SQL ask

Explore variables during the a personalized SQL ask

You need to use next customized SQL inquire to get a believe what number of orders and you will do a remaining register on the Orders and you may Dealers dining tables:

Errors whenever backup columns try referenced

When your individualized SQL query recommendations backup columns, you can aquire mistakes when trying to make use of among the many articles on your investigation in Tableau. This can takes place even if the query holds true. Such as for example, think about the adopting the ask:

This new inquire is valid, nevertheless bien au_id occupation is actually ambiguous since the in this instance it is present during the both the “authors” desk and also the “titleauthor” desk. Tableau commonly get in touch with brand new query but you’ll get an enthusiastic error whenever you just be sure to use the bien au_id field. For the reason that Tableau does not discover which dining table you’re it comes down so you’re able to.

Note: It is an only behavior so you can determine line aliases that have an Since the condition whenever you can in a personalized SQL Ask. For the reason that each database has its own rules when it concerns automatically producing a column title if in case an enthusiastic alias is perhaps not used.

Change a custom made SQL inquire

  1. With the data source page, on material, double-click the personalized SQL ask regarding the analytical covering.
  2. Hover across the personalized SQL dining table regarding bodily coating until the latest arrow screens.
  3. Click the arrow and pick Change Personalized SQL Ask .
  4. On dialog box, modify the fresh individualized SQL ask.

After you drag a custom SQL inquire to your logical covering of the canvas, Tableau brings they a default identity: Customized SQL Query, Personalized SQL Query1, and stuff like that. You might change the standard name to something a great deal more significant.

With the repository web page, on the analytical layer of your fabric, get the lose-down arrow regarding custom SQL ask table and pick Rename .

You can make use of parameters for the a personalized SQL ask declaration to change a steady really worth with an active really worth. You can then improve the newest factor about workbook to change the partnership. For example, it is possible to relate solely to a personalized SQL inquire that provides web subscribers research to own a specific web page which is specified because of the an excellent pageID. Unlike having fun with a stable value to your pageID really worth in the new SQL inquire, you might enter a parameter. Following just after doing the relationship, you could potentially let you know a parameter control on the workbook. Utilize the parameter control to evolve from the pageID and eliminate into the data for every page interesting without the need to revise or backup the connection.

In Tableau Pc, you possibly can make a parameter directly from the latest Custom SQL dialog container otherwise explore any parameters which can be an element of the workbook. For folks who perform a separate parameter, it gets readily available for use in this new workbook as with any most other factor. Pick Would Variables to learn more.

To own websites currently talking about (when you look at the Tableau On the internet otherwise Tableau Servers), you can make use of a current factor had written of Tableau Desktop. You cannot would a different factor into the web authoring.

  1. To the data source webpage, regarding canvas, hover along the table up until the edit symbol displays, and then click the change button.
  2. In the bottom of your dialog field, click Type Parameter .
  3. Come across a stable really worth about SQL declaration following, on Type Factor get rid of-off diet plan select the factor we wish to use as an alternative. When you have maybe not written a factor yet ,, look for Manage a special factor . Proceed with the recommendations when you look at the Manage Details to help make a parameter.

Regarding example less than, the newest individualized SQL inquire output all of the sales which can be marked due to the fact Urgent top priority. Regarding customized SQL statement, your order concern ‘s the constant well worth. If you would like alter the link with understand the Highest top priority requests, you would have to modify the information provider.

Leave a Comment

Your email address will not be published.