3 Replies Latest reply: Aug 26, 2010 11:31 AM by Nick Borunov RSS

    Error message

      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

      [W:\ERP Development\Qlikview Development Team\Live QVD Files\SFLR_Operation_Summary.qvd]

      (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

          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

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

                • Error message

                  Are you kidding? Who is writing SQL for you? Huh?

                  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
                  [W:\ERP Development\Qlikview Development Team\Live QVD Files\SFLR_Operation_Summary.qvd]
                  (qvd)
                  WHERE (LABOUR_NO = 'ASSY RWORK') OR
                  (LABOUR_NO = 'ASSY ADDS') OR
                  (LABOUR_NO = 'TEST MODS')
                  AND
                  (CONTRACT = 'S07050720' OR CONTRACT = 'S07050721' );