For some database, you could potentially relate with a particular inquire instead of the entire investigation set
Just like the databases possess some different SQL sentence structure away from one another, new individualized SQL you use to hook up to you to database you’ll vary on personalized SQL you may use to get in touch to a different. However, playing with individualized SQL can be useful when you know exactly brand new important information and you will can make SQL inquiries.
Though there several prominent good reason why you might use personalized SQL, you can make use of customized SQL to help you connection your computer data around the tables, recast industries to do get across-database touches, reconstitute or reduce the sized your data to own investigation, etcetera.
For Do well and you will text file research sources, this 1 is obtainable merely in the workbooks which were made before Tableau Pc 8.2 or while using Tableau Desktop computer toward Window toward heritage commitment. For connecting to Do just fine or text message data files by using the legacy union, relate with the latest document, and in new Unlock dialogue field, click the Unlock shed-off selection, then see Discover having History Union .
NOTE: Starting with Tableau 2020.2, history Do well and Text connections are not any offered served. See the Legacy Partnership Alternatives document in Tableau Community to have selection to presenting brand new legacy union.
Relate with a custom SQL ask
After you click Ok, the fresh inquire operates in addition to custom SQL query table appears during the the brand new analytical coating of one’s material. Simply relevant industries on the custom SQL ask display from the studies grid towards the Data source webpage. (more…)