Problema
When trying to refresh a data extract containing custom SQL, the following error might occur:ERROR: column reference "<field name>" is ambiguous; Error while executing the query
Data dell'ultima modifica: 07 Apr 2023
Ambiente
- Tableau Desktop
- Tableau Data Extract
- Custom SQL
Soluzione
Verify that the SQL Query completes successfully when run directly against the database. If the query does not complete successfully, work with your database administrator to address issues in the query.Causa
The error occurs within the data source and is not related to Tableau.Ulteriori informazioni
More information on the "Column reference "<name>" is ambiguous error can be found below:- Identifier Qualifiers at MySQL
- 8 Tips Absolute Beginners can Use to Fix SQL Queries at Vertabelo Academy
Grazie per aver inviato il tuo feedback sull'efficacia dell'articolo.
Apri nuovo caso
Continua la ricerca
Knowledge base
Community
Guida
Formazione e tutorial