4 Replies Latest reply: Aug 30, 2013 5:58 AM by Vishwaranjan Kumar RSS

    Field not found in preceding load but is found in resident

      Hi,

       

      A quick query as I must be missing something obvious here.

       

      Why do I get 'Field Order Date not found' error in this preceding load:

       

      FarmerStatistics:

      LOAD
      [Order Date];
      LOAD

      [Farmer Address QA ID], [Farmer ID]

      FROM QVDs\FarmerAddresses.qvd (qvd);
      JOIN
      LOAD
      [Farmer Address QA ID], [Order Number], [Order Date]
      FROM QVDs\Orders.qvd (qvd);

       

      But the resident load works fine:

       

      LOAD

      [Farmer Address QA ID], [Farmer ID]

      FROM QVDs\FarmerAddresses.qvd (qvd);
      JOIN
      LOAD
      [Farmer Address QA ID], [Order Number], [Order Date]
      FROM QVDs\Orders.qvd (qvd);

      LOAD [Order Date]
      RESIDENT FarmerStatistics;