Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Field Not Found in LOAD

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.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

maybe

where not exist (KA, NUM_SALES)


KA of SALES_K

NUM_SALES of 2014 qvd

View solution in original post

2 Replies
maxgro
MVP
MVP

maybe

where not exist (KA, NUM_SALES)


KA of SALES_K

NUM_SALES of 2014 qvd

Not applicable
Author

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