topic Stop load after first record in QlikView

Stop load after first record

Tue, 02 Jun 2009 23:54:19 GMT

Hello,

I'm reading a file whose first record is just ahead showing the date the file was created. The second record is the field list and the rest is data. My first step is to load the file to get the date from the first record and load it into a variable, which will be used to show the user how current the data is. After that, it's a normal load of the data. Here what the script does...

FindDate:
LOAD
@2 AS InvHistInfoFileDate
FROM
[$(vDataFolder)\QlikBillingInfo.txt] (ansi, txt, delimiter is ';', explicit labels, msq)
WHERE
RecNo()=1;

LET vInvHistInfoFileDate = num(peek('InvHistInfoFileDate', 0, 'FindDate'));

DROP TABLE FindDate;

It works perfectly, but I'm finding it takes a long time to get the date. I'm guessing that it's reading the entire file just to find out there's only one record with RecNo()=1.

Any ideas on how I can make the load script actually stop after the first record and move on?

Thanks,
Dino

Stop load after first record

Anonymous — Wed, 03 Jun 2009 01:09:07 GMT

Dino,
Use this:
First 1;
LOAD
...
(I often use "first 100" for script testing to avoid long load.)

Stop load after first record

Wed, 03 Jun 2009 01:52:08 GMT

Yep, that did it...I was even able to do away with the WHERE clause.

That was way too simple - somehow, I'm thinking I should have already known how to do this. 😞

Thanks,
Dino

Stop load after first record

Anonymous — Wed, 03 Jun 2009 02:15:01 GMT

That's not a problem. I'm still finding, after many years using QV, things and solutions I don't know, sometimes simple...

Stop load after first record

Wed, 03 Jun 2009 04:29:25 GMT

Hi,

I would suggest you try the "first" function. simply put First 1 before Laod and it will only laod one record. I have not tested it but it's worth a try I think.

Stop load after first record

Wed, 03 Jun 2009 04:31:10 GMT

sorry guys I did not see that Michael ahd already replied to this.

topic Stop load after first record in QlikView

Stop load after first record

FindDate:LOAD @2 AS InvHistInfoFileDateFROM [$(vDataFolder)\QlikBillingInfo.txt] (ansi, txt, delimiter is ';', explicit labels, msq)WHERE RecNo()=1;

LET vInvHistInfoFileDate = num(peek('InvHistInfoFileDate', 0, 'FindDate'));

DROP TABLE FindDate;

Stop load after first record

Stop load after first record

Stop load after first record

Stop load after first record

Stop load after first record

FindDate:
LOAD
@2 AS InvHistInfoFileDate
FROM
[$(vDataFolder)\QlikBillingInfo.txt] (ansi, txt, delimiter is ';', explicit labels, msq)
WHERE
RecNo()=1;