Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Reply
Allardata
Creator
Creator

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?