topic Data Load in QlikView

Data Load

Santhoshmdm — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I was trying to load an excel, which has 1055 records plus heading 1056, when the load data file it shows the message 1057 records fetched, not sure why extra records are fetched. Because of which I am not able to extract the last record, using the Peek() function, as when I use -1, it is extracting the last record as blank. Can anybody help on this question please.

Thanks in advance

Re: Data Load

MayilVahanan — Mon, 29 Mar 2021 03:58:43 GMT

HI @Santhoshmdm

Might be, you have 2 or more blank rows in your excel at the end.

Try like below

Load * from yourexcelfile where Len(Trim(FieldName1))> 0;

replace fieldname1 with your excel fieldname which doesn't have blank value.

Hope it helps.

Re: Data Load

Santhoshmdm — Mon, 05 Apr 2021 07:48:47 GMT

Thank you