Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER

Text file loading resistant to extra CF/LR

Master II
Master II

Text file loading resistant to extra CF/LR

One of the strongest side of QlikView is the build-in powerful ETL layer that allows you to import data from various sources. Sooner or later QlikView developer have to load some old huge unique and extremely valuable ascii file that sometimes contains a few odd line feed (LF or \n) or carriage return (CR or \r) symbols. As a result strings are divided into subsequent rows.


You just can’t load it as delimited file directly into QlikView. The power of ‘transform step’ can’t help here too.

Nevertheless QlikView can easily handle it with a few tricks. I decide to write a detailed guide as there are pitfalls that must be explained carefully.

whiteline

Labels (1)
Attachments
Comments
MVP & Luminary
MVP & Luminary

Hi whiteline,

this is everytime a challange and you provide an interesting approach. Today I had proposed a similar solution which could omit the STORE. Maybe you can take this kind of solution also into account:

Line terminator while loading text file other than default \n

- Ralf

0 Likes
Creator II
Creator II

Pardon my ignorance but why is CF/LR.

Would you explain to me ?

0 Likes
MVP & Luminary
MVP & Luminary

I guess it is a typo in the titel. Must be CR/LF.

0 Likes
Creator II
Creator II

Sorry me. I did not read the whole text.

Thanks.

0 Likes
Master II
Master II

Oops. Thanks. I will correct the title with next version.

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2013-09-02 04:28 PM
Updated by: