Data Load

[Santhoshmdm]

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

[MayilVahanan · Accepted solution]

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.

[Santhoshmdm]

Thank you