Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Master II
Master II

Xls files loading issue

Hi,

I am loading bulk xls file into qlikview.

All of a sudden getting this error.

Please help me.

Error: File extdata.cpp, Line 2787


Thanks in advance.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Hi,

If you want to replace that empty value to some other value then use Alt() like below.

Let BeginDate =  Alt(Peek('MonthBegin',0), Today());


Regards,

Jagan.

View solution in original post

12 Replies
Champion III
Champion III

Could you post your script.?

Hi,

What is your script for loading all xls file.

what is document log suggest??

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
MVP
MVP

MVP & Luminary
MVP & Luminary

Hi,

Check the latest excel files, is there any format change?  Can you attach the script you are using for this?

Regards,

Jagan.

MVP & Luminary
MVP & Luminary

Also copy the latest files to some other folder and check whether the issue comes again?  I hope this is excel file issue.

Regards,

Jagan.

Master II
Master II

Hi All,

This is the script.

Failing at the red color lines.

Error: File extdata.cpp, Line 2787

BeginDate:

LOAD * INLINE [

  

]

Script:

Emp:

LOAD Ename,

    Empno,

    Sal

FROM

[$(EmpFiles)*_Sal.qvd]

(qvd)

;

TimePeriod:

LOAD Year,

    MonthNum,

    YearMonth,

    Month,

    BeginDate,

    EndDate

FROM

[$(EmpFiles)TimePeriod.qvd]

(qvd) where Year > 2015 and Year < 2016;

Date:

LOAD

    YearMonth as Month

Resident

Calendar where RunDate = Today();

Let  =  Peek('Month',0);

MonthBegin:

LOAD

    Date(Min(BeginDate)) as MonthBegin

Resident

Calendar where YearMonth = Peek('Month',0);

DROP Table Date;

Let BeginDate =  Peek('MonthBegin',0);

BeginDate:

LOAD * INLINE [

    $(BeginDate)

];

DROP Table MonthBegin;

STORE BeginDate into [$(BeginDateFile)BeginDate.txt] (txt);

DROP Table BeginDate;

MVP & Luminary
MVP & Luminary

Hi,

I think you are getting Empty value in the BeginDate variable, check it.

Regards,

Jagan.

Master II
Master II

Yes. it is getting empty value.