Incremental Load , Field Not Found

Fri, 27 Mar 2015 13:01:11 GMT

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

Re: Incremental Load , Field Not Found

MK_QSL — Fri, 27 Mar 2015 13:03:24 GMT

try

'$(Last_Update_PDCH)'

Re: Incremental Load , Field Not Found

jonathandienst — Fri, 27 Mar 2015 13:12:50 GMT

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

Re: Incremental Load , Field Not Found

Fri, 27 Mar 2015 13:13:25 GMT

it works , Thank you

topic Re: Incremental Load , Field Not Found in QlikView

Incremental Load , Field Not Found

Re: Incremental Load , Field Not Found

Re: Incremental Load , Field Not Found

Re: Incremental Load , Field Not Found