topic Re: Xls files loading issue in QlikView

Xls files loading issue

qlikviewwizard — Wed, 06 Jan 2016 06:43:20 GMT

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.

Re: Xls files loading issue

Chanty4u — Wed, 06 Jan 2016 06:46:14 GMT

hi,

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

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

chk abve links

thnks

Re: Xls files loading issue

tamilarasu — Wed, 06 Jan 2016 06:47:08 GMT

Could you post your script.?

Re: Xls files loading issue

PrashantSangle — Wed, 06 Jan 2016 06:47:10 GMT

Hi,

What is your script for loading all xls file.

what is document log suggest??

Regards

Re: Xls files loading issue

Kushal_Chawda — Wed, 06 Jan 2016 06:52:01 GMT

See the below link

Dynamically Loading Multiple Excel Files

Re: Xls files loading issue

jagan — Wed, 06 Jan 2016 07:00:02 GMT

Hi,

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

Regards,

Jagan.

Re: Xls files loading issue

jagan — Wed, 06 Jan 2016 07:00:55 GMT

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.

Re: Xls files loading issue

qlikviewwizard — Wed, 06 Jan 2016 07:48:42 GMT

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;

Re: Xls files loading issue

jagan — Wed, 06 Jan 2016 07:51:33 GMT

Hi,

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

Regards,

Jagan.

Re: Xls files loading issue

qlikviewwizard — Wed, 06 Jan 2016 07:52:54 GMT

Yes. it is getting empty value.

Re: Xls files loading issue

tamilarasu — Wed, 06 Jan 2016 07:56:36 GMT

Check the below 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 vMonth = Peek('Month',0);

MonthBegin:

LOAD

Date(Min(BeginDate)) as MonthBegin

Resident

Calendar where YearMonth = $(vMonth);

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;

Re: Xls files loading issue

jagan — Wed, 06 Jan 2016 07:58:36 GMT

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.

Re: Xls files loading issue

jagan — Wed, 06 Jan 2016 08:01:54 GMT

Hi,

Alt() will replace Null value with the given values.

Regards,

Jagan.