You can use the following custom SQL query to append the second table, December, to the first table, November: In some cases your database does not support this option, so you can use custom SQL instead.įor example, suppose you have the following two tables: November and December. If you need to append data to each other, you can use the union option in the physical layer of the canvas in Tableau. Only relevant fieldsįrom the custom SQL query display in the data grid on the Data Source page.įor more information about the logical and physical layers of the canvas, see The Tableau Data Model. When you click OK, the query runs and the custom SQL query table appears in the logical layer of the canvas. The query must be a single SELECT* statement. Type or paste the query into the text box. Connect to a custom SQL queryĪfter connecting to your data, double-click the New Custom SQL option on the Data Source page. See the Legacy Connection Alternatives document in Tableau Community for alternatives to using the legacy connection. NOTE: Beginning with Tableau 2020.2, legacy Excel and Text connections are no longer supported. To connect to Excel or text files using the legacy connection, connect to the file, and in the Open dialog box, click the Open drop-down menu, and then select Open with Legacy Connection. Though there are several common reasons why you might use custom SQL, you can use custom SQL to union your data across tables, recast fields to perform cross-database joins, restructure or reduce the size of your data for analysis, etc.įor Excel and text file data sources, this option is available only in workbooks that were created before Tableau Desktop 8.2 or when using Tableau Desktop on Windows with the legacy connection. However, using custom SQL can be useful when you know exactly the information you need and understand how to write SQL queries. Because databases have slightly different SQL syntax from each other, the custom SQL you use to connect to one database might be different from the custom SQL you might use to connect to another.
To a specific query rather than the entire data set.
0 kommentar(er)
