Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikviewwizard
Honored Contributor 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

Re: Xls files loading issue

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
Chanty4u
Esteemed Contributor III

Re: Xls files loading issue

Re: Xls files loading issue

Could you post your script.?

Re: Xls files loading issue

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.

Re: Xls files loading issue

MVP & Luminary
MVP & Luminary

Re: Xls files loading issue

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

Re: Xls files loading issue

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.

qlikviewwizard
Honored Contributor II

Re: Xls files loading issue

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

Re: Xls files loading issue

Hi,

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

Regards,

Jagan.

qlikviewwizard
Honored Contributor II

Re: Xls files loading issue

Yes. it is getting empty value.