Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe something like this:
And then datamodel looks like this:
Hope this helps.
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/