"Field not found" after adding excel data via initial app launcher

Fri, 22 May 2015 06:49:19 GMT

Hi,

I'm currently trying to learn qlik sense desktop. From our database I dumped data to an excel file, added the directory as lib and selected the file as source. After selecting relevant data qlik starts reading in all data from excel sheet. Works fine. Second step I add an other excel using the already set up lib. Again I select the relevant data and add the skript into my data sources. Now I need to reload because this time qlik does NOT read in the data from excel file. Therefore I press "reload data" earning an error from the first excel sheet: "field not found". well, it's def. there... Why does it work the first time and fails the second time with nothing else changed but an additional data source?

Here is my resulting skript:

porder2products:

LOAD

PRODUCT_ID,

PORDER_ID,

POSITION,

PRICE,

RETURN_STATUS_ID

FROM [lib://Desktop/porder2product_mai.xlsx]

(ooxml, embedded labels, table is [p2p]);

porder:

LOAD

PORDER_ID,

COMMISSION_ID,

PARCEL_ID,

WEIGHT,

PLC,

PARCEL_STATUS_ID,

DISPATCH_TYPE_ID,

MAIN_PRODUCT_ID,

TSCREATE,

STORE_ID,

TERMINAL_ID,

TSUPDATE,

PARCEL_ID_UNIQUE,

LICENSE_PLATE

FROM [lib://Desktop/porderparcels_mai.xlsx]

(ooxml, embedded labels, table is [pp]);

Re: "Field not found" after adding excel data via initial app launcher

Allardata — Wed, 27 May 2015 14:53:19 GMT

Your steps seem correct.

On which of the two loads statements does the error appear?

I'd start with checking some assumptions:

1) Is your first file indeed on the desktop?

2) Is your second file indeed on the desktop?

3) Does your first file contain a sheet named "p2p" with all those 5 fields?

4) Does your second file contain a sheet named "pp" with all those fields?

topic Re: "Field not found" after adding excel data via initial app launcher in Connectivity & Data Prep

"Field not found" after adding excel data via initial app launcher

Re: "Field not found" after adding excel data via initial app launcher