Loading

Converting a Connection to Custom SQL

Дата публикации: Apr 13, 2024
Задача
How to convert a connection to a table or joined tables into a custom SQL query in Tableau Desktop
Действия

Option 1: When connecting to data sources that support SQL connections

  1. Connect to the data source.
  2. Drag at least one table into the canvas area.
    • Optional: Drag additional tables into the canvas area to create joins.
  3. Navigate to Data > Convert to Custom SQL

Option 2: When connecting to Excel

  1. Connect to Excel with the legacy data connector
    1. Connect to the file.
    2. In the Open dialog box, click the Open drop-down menu, and then select Open with Legacy Connection
  2. Drag at least one table into the canvas area.
    • Optional: Drag additional tables into the canvas area to create joins.
  3. Navigate to Data > Convert to Custom SQL
Дополнительные ресурсы

Note: The Convert to Custom SQL option may be grayed out or missing if the data source does not support a SQL connection, or if there is a cross-database join in the canvas area. 

Connecting to a Custom SQL Query
 

Номер статьи базы знаний

001458320

 
Загрузка
Salesforce Help | Article