問題
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
上次修改日期 : 07 Apr 2023
環境
- Tableau Desktop
- Tableau Data Extract
- Custom SQL
解決方法
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.原因
The error occurs within the data source and is not related to Tableau.其他資訊
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
感謝您針對本文的效益提供意見回饋。
開啟新案例
繼續搜尋
知識庫
社群
產品說明
訓練及教學課程