Tableau Prep Builder Cannot Show A Field By Cusom SQL With Salesforce Connector If All Rows Are NULL
Published: 29 Jun 2022 Last Modified Date: 25 Jul 2022
A field is not displayed in Tableau Prep Builder using customer SQL with Salesforce connector is all rows are null.
Tableau Prep Builder 2022.1.1
Insert some data in the Salesforce column
Avoid use of customer SQL and use standard object and select fields only.
This is by design. When a custom SQL is used, the column names are derived from the results returned by Salesforce API. If there is no data in the column, no data is returned and the field is not displayed.
Thank you for providing your feedback on the effectiveness of the article.