Field not found in preceding load but is found in resident

[#1]

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;

[CELAMBARASAN · Accepted solution]

Flow of the script

First this will executed

LOAD
[Order Date];
LOAD

[Farmer Address QA ID], [Farmer ID]

FROM QVDs\FarmerAddresses.qvd (qvd);

Then only order date joins to the above table

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

You need to use resident load only.

[#3]

try this in preceding load

FarmerStatistics:

LOAD

[Farmer Address QA ID],
[Order Date];

LOAD

[Farmer Address QA ID],

[Order Number],

[Order Date]

FROM QVDs\Orders.qvd (

qvd);

JOIN

LOAD

[Farmer Address QA ID], [Farmer ID]

FROM QVDs\FarmerAddresses.qvd (

qvd);

[#4]

Ok thanks.  I thought it was from bottom up.  Thanks for your quick response!

[#5]

in your preceding load  field not available in a table on which you do preceding load

FarmerStatistics:

LOAD
[Order Date];  // this field not in below table so error field not found
LOAD

[Farmer Address QA ID], [Farmer ID]

FROM QVDs\FarmerAddresses.qvd (

qvd);