Loading

Unable to run CTE (Common Table Expressions) When Using "With" Command

Дата публикации: Apr 30, 2025
Описание

When using the With command in custom SQL, a syntax error occurs. 

Cause:

Tableau wraps all custom SQL with a Select statement. 

Решение
Use initial SQL, if it is available for the data source. For more information, see Using Common Table Expressions and Run Initial SQL.
Дополнительные ресурсы

Writing or modifying specific Custom SQL queries to achieve a desired effect is outside the scope of Support. 

More information about this can be found in the following Community Idea: CTE compatibility with SQL Server.
 

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

001473950

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