topic Error message in QlikView

Error message

Thu, 26 Aug 2010 14:58:41 GMT

My problem is an error message is coming up saying Field not found - <PROJECT_ID>. I don't understand why it is not found. Any help would be grateful to resolve the problem.

OP_SUMMART:

Qualify *;

unqualify PROJECT_ID;

LOAD CONTRACT as PROJECT_ID ,

COMPANY_ID,

LABOUR_NO,

PART_NO,

REAL_FINISH,

DELAY_IN_DAYS,

PCT_NOT_APPVD,

QTY_HRS_PLANNED,

QTY_HRS_ACTUAL

FROM

(qvd)

WHERE (LABOUR_NO = 'ASSY RWORK') OR

(LABOUR_NO = 'ASSY ADDS') OR

(LABOUR_NO = 'TEST MODS')

AND

(PROJECT_ID = 'S07050720' OR PROJECT_ID = 'S07050721' );

Error message

Thu, 26 Aug 2010 15:03:44 GMT

Because at the load time of the statement there is no PROJECT_ID field. There is a CONTRACT field. After that you can use the PROJECT_ID field.

Error message

Thu, 26 Aug 2010 15:13:01 GMT

How do i write it in the syntax to overcome the error.

Error message

Thu, 26 Aug 2010 15:31:53 GMT

Are you kidding? Who is writing SQL for you?

All what you need is just replace PROJECT_ID in where clause by CONTRACT.



OP_SUMMART:
Qualify *;
unqualify PROJECT_ID;
LOAD CONTRACT as PROJECT_ID ,
COMPANY_ID,
LABOUR_NO,
PART_NO,
REAL_FINISH,
DELAY_IN_DAYS,
PCT_NOT_APPVD,
QTY_HRS_PLANNED,
QTY_HRS_ACTUAL
FROM

(qvd)
WHERE (LABOUR_NO = 'ASSY RWORK') OR
(LABOUR_NO = 'ASSY ADDS') OR
(LABOUR_NO = 'TEST MODS')
AND
(CONTRACT  = 'S07050720' OR CONTRACT  = 'S07050721' );