Incremental Load , Field Not Found

[#1]

Hi,

i was  working  on this script :

Fait_Qualite_GPRS_PDCH:

LOAD id_Date,

     id_Fournisseur,

     id_Objectif,

     PDCH_Allocation_Success,

     PDCH_Allocation_Failure,

     [IP_Transfer_Interrupt_DL _mn]

FROM

D:\PFE-TT\Qlick\BD\Fait_Qualite_GPRS_PDCH.qvd

(qvd);

Last_Update_PDCH :

LOAD max(id_Date) as maxdatePdchh

Resident Fait_Qualite_GPRS_PDCH ;

////store last modified date to a variaable

LET Last_Update_PDCH = Peek ('maxdatePdchh',0,'Last_Update_PDCH') ;

DROP Table Fait_Qualite_GPRS_PDCH ;

incremental:

LOAD id_Date,

     id_Fournisseur,

     id_Objectif,

     PDCH_Allocation_Success,

     PDCH_Allocation_Failure,

     [IP_Transfer_Interrupt_DL _mn]

FROM

D:\PFE-TT\Qlick\gprs.xlsx

(ooxml, embedded labels, table is Fait_Qualite_GPRS_PDCH) Where id_Date >= $(Last_Update_PDCH);

Concatenate

LOAD id_Date,

     id_Fournisseur,

     id_Objectif,

     PDCH_Allocation_Success,

     PDCH_Allocation_Failure,

     [IP_Transfer_Interrupt_DL _mn]

FROM

D:\PFE-TT\Qlick\BD\Fait_Qualite_GPRS_PDCH.qvd

(qvd) Where not Exists (id_Date);

STORE incremental into D:\PFE-TT\Qlick\BD\Fait_Qualite_GPRS_PDCH.qvd;

DROP Table incremental ;

But i keep getting the "field not found "error for "Last_Update_PDCH" on "incremental" table

Could anyone please help me with this?

Regards,

Ameni

[MK_QSL · Accepted solution]

try

'$(Last_Update_PDCH)'

[jonathandienst]

The variable is not being populated. Does the first QVD contain any rows? Is the id_Date field populated? The peek does not appear to be returning anything.

HTH

Jonathan

[#4]

it works , Thank you