topic Loading a Large Text File in QlikView

Loading a Large Text File

Wed, 14 May 2014 13:07:19 GMT

Hi,

I'm having a problem loading a text file with 1.4 milions lines...

LOAD ExternalQABatchKey,

SalesTransactionLineKey,

PharmacyID,

DayKey,

SalesDateTime,

HMRFixedProductPackCode,

ProductID,

ProductName,

UnitPrice,

QuantitySold,

PricePaid

FROM

SalesTransactionLine_OutliersData.txt

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

It only loads next to 700.000 lines and no error is registered!

Thanks in advance,

Francisco

alexandros17 — Wed, 14 May 2014 13:10:55 GMT

I know it is a heavy work but probably there is a special Character that stop loading ... try to find it

(If you know the line where it stops, create a second file from that point on and verify if it loads)

Wed, 14 May 2014 13:12:01 GMT

Can you upload a portion of the txt file? This probably has something to do with how QV is parsing the file.

Wed, 14 May 2014 13:53:44 GMT

I found the problem in the exporting tool that made the file!

Thanks