Where exists : field not found

domiho123 — Thu, 18 Apr 2013 06:53:21 GMT

Gents, Ladies,

I'm trying to add missing months in a table using CONCATENATE LOAD and a Where Exists() clause. The message I am receiving that a field is missing (see screenshot).

The version is 9.00.7646.9 SR6 and cannot upgrade.

The code is:

***************************************************************************************************************

LET varMinDate = Num(MakeDate(2010,01,01));

LET varMaxDate = Num(Today());

DateField_Temp:

LOAD $(varMinDate) + RowNo() -1 as Num,

Date($(varMinDate) + RowNo() -1) as TempDate

AutoGenerate

$(varMaxDate) - $(varMinDate) + 1;

// load months of each year (by choosing first of the month)

DateField:

LOAD

TempDate

Resident DateField_Temp where Day(TempDate) = '1';

drop table DateField_Temp;

BE_Team:

LOAD

MEDEWERKER_NR as %EMPLOYEE_Key,

UNIT,

PRCTR,

IN, // Date format is DD-MM-YYYY (system setting is DD-MM-YYYY)

UIT,

TEAM,

PM_NR,

PM_VOORNAAM,

PM_NAAM,

LEVEL,

[INTERN/EXTERN],

MonthStart(IN) as INMonthStart

FROM $(vDirEmp)\BE_Team - Employee.qvd (qvd);

concatenate

LOAD

TempDate as IN

Resident DateField Where Exists (IN);

***************************************************************************************************************

Please advice.

Dominique.

Re: Where exists : field not found

Thu, 18 Apr 2013 13:35:32 GMT

Try

LOAD

TempDate as IN

Resident DateField Where Exists (IN,TempDate);

Re: Where exists : field not found

domiho123 — Fri, 19 Apr 2013 06:06:45 GMT

Thanks al lot Matthew! I simply works.

I have tried probably everything except that one

topic Where exists : field not found in QlikView

Where exists : field not found

Re: Where exists : field not found

Re: Where exists : field not found