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.

[tamilarasu]

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;

[jagan · Accepted solution]

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.

[jagan]

Hi,

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

Regards,

Jagan.