KNOWLEDGE BASE

Decimal Numbers Interpreted as NULL in Tableau Desktop


Published: 07 Sep 2016
Last Modified Date: 14 Aug 2017

Issue

When connecting to a text file decimal numbers are not interpreted correctly. Trying to change the data type results in the numbers becoming NULL

Environment

  • Tableau Desktop 10.0.0
  • Text Files

Resolution

1) Connect to the .txt file. 

2) Click the small arrow displaying on top of .txt file on the Data pane in Tableau and select "Text file properties". 

3) In the dialog menu change the Locale of the file to English: 

This will make Tableau recognize all the dots as decimal separators and recognize the values as Decimal numbers by default.

Cause

This issue often occurs because a dot (.) is used as decimal separator, but Tableau uses a non-English locale by default. 
The other way around is also possible: a comma (,) is used as decimal separator, but English locale is set in Tableau.
Did this article resolve the issue?