Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hi Friends,can any one help on how to Load a Text data with multiple lines with out an delimiter

Hi Friends,

In a text file i have lot of transactions eg: 9220 .each  line contains 256 bytes

each transaction contains 2 or 3 or 4  or 5 or 6......so many lines.

Now i want to load this text file into  QlikView, but each and every line they are split into according to their requirement i.e 9220 is the starting of the transaction  and 9221,9222,9223,9223,9240 lines are comes under 9220 transaction only.


2 Replies
sinanozdemir
Specialist III
Specialist III

Maybe something like this:

Capture.PNG

And then datamodel looks like this:

Capture.PNG

Hope this helps.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Take a look at this example to see if is what you are looking for:

Qlikview Cookbook: Load Input File Containing Multiple Record Types http://qlikviewcookbook.com/recipes/download-info/load-input-file-containing-multiple-record-types/