Last Modified Date: 23 Oct 2023
Environment
- Tableau Desktop
- Text Files
Resolution
To make Tableau recognize all the dots as decimal separators and recognize the values as Decimal numbers by default, follow the step below:- Connect to the .txt file.
- On the data source page, click the small arrow displaying on top of .txt file on the Data pane in Tableau and select "Text file properties". (This option is for text files. It will not be available for Excel or other formats.)
- In the dialog menu change the Locale of the file to English.
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.Additional Information
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials