KNOWLEDGE BASE

White Space is Added to Custom SQL Queries


Published: 23 Aug 2017
Last Modified Date: 17 Nov 2017

Issue

When using a custom SQL query and changing the data type of a field to Date or Date & Time, then Tableau Desktop inserts carriage returns to the beginning and ending of the custom SQL query.

Environment

  • Tableau Desktop 10.3.0-10.3.3
  • Custom SQL queries

Resolution

Option 1

Convert fields to the date data type in the custom SQL query rather than in the Tableau Desktop interface. 

Option 2

Upgrade to Tableau Desktop 10.2.5, 10.3.3, 10.3.4 or 10.4.1 or later and only convert fields to the date data type on live connection before extracting the connection. For more information, see Upgrading Tableau Desktop in Tableau Help.

 

Cause

This behavior is related to known issues (IDs: 659319 and 686741) that has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?