KNOWLEDGE BASE

Not All Data Imports When Connecting to Text Files


Published: 22 Aug 2013
Last Modified Date: 31 May 2016

Issue

When you import data from a text (.txt) file into Tableau Desktop, some values might not import, and Tableau Desktop might display "null" for the values that weren't imported.

Environment

  • Tableau Desktop
  • Text files

Resolution

Option 1: Connect to Excel instead

  1. Move the data into a Microsoft Excel file.
  2. In Tableau Desktop, connect to the Excel file.

Option 2: Use a schema.ini file with legacy connection

  1. Create and use a schema.ini file. The schema.ini file should specify that fields with Long Integer data types should be treated as Double data type. For more information, see Schema.ini File (Text File Driver) in the Microsoft Dev Center. Creating the schema.ini file will allow the Microsoft JET Database Engine to correctly recognize data types.
  2. If using Tableau Desktop 8.2 or later versions, in Tableau Desktop, browse to your data file, click the drop-down arrow on Open, and then select Open with Legacy Connection.

Cause

When columns are more than 2^31 = 2147483648, the driver is unable to read the numbers, because it uses a 4-byte integer, and larger numbers do not fit.

When using Excel, the driver reads cells as double data type, so the error doesn't occur.
Did this article resolve the issue?