Database

Resolve Tableau rows dropping issue

Reading data correctly from a data source is the basis of the correct and meaningful visualization! This is true for all visualization tools and Tableau is no exception.

Issue

A peculiar Issue was faced with Tableau data reading once when it suddenly started dropping the data rows that it was reading from a csv file. The environment setup was as follows:

There were ^ delimited csv files getting generated daily from Oracle database by using PL/SQL code.

The files were fairly large (700 MB).

There were more than 100 columns in the csv file with almost 20 measure columns.

These csv files were then used to be appended to the Tableau Data extract (TDE) daily.

Continue reading →

Posted by Akihiko Katayama, 0 comments