Loading

Text or CSV File Data Source Does Not Return All Rows

Дата публикации: Apr 13, 2024
Описание
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.

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)
Решение
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
 
 
Дополнительные ресурсы
Text File
Configure your data set
Номер статьи базы знаний

001474069

 
Загрузка
Salesforce Help | Article