Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
maybe
where not exist (KA, NUM_SALES)
KA of SALES_K
NUM_SALES of 2014 qvd
maybe
where not exist (KA, NUM_SALES)
KA of SALES_K
NUM_SALES of 2014 qvd
OMG!!! Can't see the forest for the trees...thanks