Loading

Converting a Connection to Custom SQL

Publiseringsdato: Apr 13, 2024
Oppgave
How to convert a connection to a table or joined tables into a custom SQL query in Tableau Desktop
Trinn

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
Flere ressurser

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
 

Knowledge-artikkelnummer

001458320

 
Laster
Salesforce Help | Article