Where exists : field not found

[domiho123]

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.

[#2 · Accepted solution]

Try

LOAD

          TempDate as IN

Resident DateField Where Exists (IN,TempDate);

[domiho123]

Thanks al lot Matthew! I simply works.

I have tried probably everything except that one