Problème
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
Date de dernière modification : 07 Apr 2023
Environnement
- Tableau Desktop
- Tableau Data Extract
- Custom SQL
Résolution
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.Cause
The error occurs within the data source and is not related to Tableau.Informations supplémentaires
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
Merci de nous avoir donné votre avis sur l’efficacité de l’article.
Ouvrir un nouveau cas
Continuer la recherche
Base de connaissances
Communauté
Aide produit
Formation et tutoriels