Xls files loading issue

[qlikviewwizard]

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.

[Chanty4u]

hi,

https://community.qlik.com/message/771284#771284

https://community.qlik.com/message/666994#666994

chk abve links

thnks

[tamilarasu]

Could you post your script.?

[PrashantSangle]

Hi,

What is your script for loading all xls file.

what is document log suggest??

Regards

[Kushal_Chawda]

See the below link

Dynamically Loading Multiple Excel Files

[jagan]

Hi,

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

Regards,

Jagan.

[jagan]

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]

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;

[jagan]

Hi,

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

Regards,

Jagan.

[qlikviewwizard]

Yes. it is getting empty value.