Because databases enjoys quite additional SQL syntax out of both, this new personalized SQL you use for connecting to you to definitely databases you’ll differ on the individualized SQL you may use to connect to another. Although not, having fun with customized SQL can be handy once you know precisely the brand new important information and you can understand how to generate SQL concerns.
However, there are a couple of common reason you might use individualized SQL, you need to use individualized SQL to commitment your computer data all over tables, recast sphere to execute mix-databases matches, restructure otherwise slow down the size of your data to have data, etcetera.
To own Excel and text message document study present, this package can be obtained merely into the workbooks that were created before Tableau Pc 8.2 otherwise when using Tableau Desktop on Windows to your legacy commitment. For connecting to Do just fine otherwise text message documents making use of the history connection, interact with the fresh new file, plus in this new Open dialogue container, click the Unlock drop-off diet plan, and then pick Discover which have Legacy Connection .
NOTE: Beginning with Tableau 2020.2, legacy Do well and you can Text message associations are no longer supported.