![]() ![]() Existing workbooks created with these legacy connections will continue to work until 2019.2, when all support for legacy connections will be removed. Note: Starting in Tableau 2019.1, you can no longer create a new Legacy Excel or Text connection. When using Excel, the driver reads cells as double data type, so the error doesn't occur. NOTE: See note in Additional Information below.ĬauseWhen 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. In Tableau Desktop, browse to your data file, click the drop-down arrow on Open, and then select Open with Legacy Connection.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. ![]() The schema.ini file should specify that fields with Long Integer data types should be treated as Double data type. ![]() Option 2: Use a schema.ini file with legacy connection In Tableau Desktop, connect to the Excel file.Move the data into a Microsoft Excel file.Resolution Option 1: Connect to Excel instead IssueWhen 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |