Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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;

1 Solution

Accepted Solutions

Re: Field not found in preceding load but is found in resident

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.

4 Replies

Re: Field not found in preceding load but is found in resident

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.

Not applicable

Re: Field not found in preceding load but is found in resident

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);

Not applicable

Re: Field not found in preceding load but is found in resident

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

Not applicable

Re: Field not found in preceding load but is found in resident

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);

Community Browser