Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.
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.
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);
Ok thanks. I thought it was from bottom up. Thanks for your quick response!
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);