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

[#1]

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

[Allardata]

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?