I am connecting to a csv, 900k, rows via the legacy connector as I need to use custom sql. The issue I am finding is that if I connect live, the number of rows are limited. This seems to be an arbitrary number, sometimes 100k, sometimes 350k and anything in between. If I take an extract then all the rows are included.
The problem is that the sql runs before the extract so I don't get all the rows included in the sql query.
Does anyone know of a limit or a way around this? I am using 9.0 but have also tried in 9.2 with the same results.
Cheers
Try EasyMorph | Data transformation and analysis tool to import .csv file, filter and then export directly to tableau's .TDE format.
The free edition allow you up to 30 transformations.
Regards,
Cristian.