KNOWLEDGE BASE

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

Issue

A field is not displayed in Tableau Prep Builder using customer SQL with Salesforce connector is all rows are null.
 

Environment

  • Tableau Prep Builder 2022.1.1
  • Windows 10
  • Salesforce connector

Resolution

  • Insert some data in the Salesforce column
  • Avoid use of customer SQL and use standard object and select fields only.

Cause

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.
 
Did this article resolve the issue?