Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Loading a Large Text File

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

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Loading a Large Text File

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

Thanks

3 Replies

Re: Loading a Large Text File

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)

Not applicable

Re: Loading a Large Text File

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

Not applicable

Re: Loading a Large Text File

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

Thanks