Field Not Found in LOAD

[#1]

Hi,

I have Field not found error in the following load script, how can I fix???

ERROR:Field not found - <KA>

SALES_K:

LOAD  DISTINCT NUM_SALES as KA

FROM

[..\QVD Data\Sales_2013.qvd]

(qvd);

SALES:

LOAD *  FROM

[..\QVD Data\Sales_2013.qvd]

(qvd);

Concatenate

LOAD *  FROM

[..\QVD Data\Sales_2014.qvd] where not exist (NUM_SALES,KA)

(qvd);

Thanks in advance,

Gino.

[maxgro · Accepted solution]

maybe

where not exist (KA, NUM_SALES)

KA of SALES_K

NUM_SALES of 2014 qvd

[#3]

OMG!!! Can't see the forest for the trees...thanks