Last Modified Date: 15 Feb 2019
- Tableau Desktop
- Tableau Prep
- Text Files
Resolution for Possibly Cause 1 (please refer to Root Cause)
Save the CSV file with ANSI, OEM, UTF-8, or UTF-16 encoding.
- In Tableau Desktop, right click the data source in the Data pane and select Edit Data Source...
- In the join area, click the drop-down arrow on the table name and then select Text File Properties
- For Character Set, select the encoding used for the CSV file.
- For Text Qualifier, select the character used to mark where text begins and ends
Make sure field separator is not displayed in data value
CausePossibly Cause 1
The file is saved with an encoding that does not match the character set setting of the connection, or the Text Qualifier is set incorrectly.
Possibly Cause 2
There are values including field separator (ex: using comma as separator but the number is displayed as 123,456)
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials