KNOWLEDGE BASE

Text or CSV File Data Source Does Not Return All Rows


Published: 25 Sep 2014
Last Modified Date: 15 Feb 2019

Issue

When you connect to a text file or CSV data source, the number of records reported by Tableau Desktop might be fewer than the number of rows in the text or CSV file.

Environment

  • Tableau Desktop
  • Tableau Prep
  • Text Files

Resolution

Resolution for Possibly Cause 1 (please refer to Root Cause)
 

Option 1: 

Save the CSV file with ANSI, OEM, UTF-8, or UTF-16 encoding.

Option 2:

  1. In Tableau Desktop, right click the data source in the Data pane and select Edit Data Source...
  2. In the join area, click the drop-down arrow on the table name and then select Text File Properties
  3. For Character Set, select the encoding used for the CSV file. ​
  4. For Text Qualifier, select the character used to mark where text begins and ends
Resolution for Possibly Cause 2

Make sure field separator is not displayed in data value
 
 

Cause

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