Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Santhoshmdm
Contributor
Contributor

Data Load

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

1 Solution

Accepted Solutions
MayilVahanan

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.

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

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.

Thanks & Regards,
Mayil Vahanan R

View solution in original post

Santhoshmdm
Contributor
Contributor
Author

Thank you