topic Re: Load First few rows of multiple files in QlikView

Load First few rows of multiple files

gerhardl — Wed, 25 Nov 2020 16:16:04 GMT

I am loading TXT files which contain the opening balance for each of our loan products. All I want is the first "Beginning Balance" value in this image:

So I wanted to use "WHERE ROWNO() < 4" for instance. The problem is that I am loading multiple files (one per product) into the same table, so the rows keep incrementing, and while my opening balance is in line 1 (excluding the headers) for this "DUNSA" product file, it will be in row 10 for the next product file.

I also thought of just loading WHERE [Outstanding Balance] = 'Beginning Balance'.... but there are 2 such records in each file.

Any way I can STOP loading after a few rows but in multiple files, or where I can stop loading each file when I get to "Profit and Loss Balance" row?

Re: Load First few rows of multiple files

sunny_talwar — Thu, 05 May 2016 10:42:23 GMT

What about using First 4

First 4

LOAD FieldName

FROM YourFile;

Re: Load First few rows of multiple files

gerhardl — Thu, 05 May 2016 10:45:49 GMT

Wow. Been struggling 20 minutes with this and didn't know about that... awesome!

Re: Load First few rows of multiple files

sunny_talwar — Thu, 05 May 2016 10:47:00 GMT

You can read about this more in the help sections:

First ‒ QlikView

Re: Load First few rows of multiple files

sunny_talwar — Thu, 05 May 2016 10:50:27 GMT

Although I think RecNo might have also worked

Where RecNo() < 4;