Loading a Large Text File

[#1]

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]

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)

[#3]

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

[#4 · Accepted solution]

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

Thanks