Field not found - Field 'MRP Date' not found

[MikeGaunt1]

Hi All, 

I cannot for the life of me figure out why Qlik cannot find this field in the below script? 

TABLE_HISTORIC:
LOAD
   "MRP Date",
    "Part Number",
    Description,
    "Vendor Number",
    Supplier,
    "PO/Req/Plnd Order",
    Item,
    "Order Type*",
    "MRP Message",
    "Rescheduling date",
    "Open Qty",
    "PO Value USD",
    "Schedule Line",
    "Delivery date",
    "Receipt Date",
    "Net Price",
    Currency,
    "Net Price USD",
    "Plant Name",
    "Purchasing Group Name",
    "MRP Controller Name",
    "MRP Controller"
    
// We get the qvd from the same path you have saved it before, unless you have changed placed where it was, then use the new path. 

FROM [lib://DataFiles/Historical_Inventory_Reduction_FY24.qvd](qvd);

Concatenate LOAD

  "MRP Date",
    "Part Number",
    Description,
    "Vendor Number",
    Supplier,
    "PO/Req/Plnd Order",
    Item,
    "Order Type*",
    "MRP Message",
    "Rescheduling date",
    "Open Qty",
    "PO Value USD",
    "Schedule Line",
    "Delivery date",
    "Receipt Date",
    "Net Price",
    Currency,
    "Net Price USD",
    "Plant Name",
    "Purchasing Group Name",
    "MRP Controller Name",
    "MRP Controller",
    today() as [load date]
    
FROM [lib://DataFiles/Inventory Reduction FY24 .xlsx]
(ooxml, embedded labels, table is Sheet1);

STORE TABLE_HISTORIC into [lib://DataFiles/Inventory Reduction FY24 .xlsx](qvd);

Now the app is meant to concatenate any load that occurs so the data can be trended. 

There is a preceding load which creates the dataset, but is now blanked from the script as the container is created. 

// Table1:
// LOAD
//     "MRP Date",
//     "Part Number",
//     Description,
//     "Vendor Number",
//     Supplier,
//     "PO/Req/Plnd Order",
//     Item,
//     "Order Type*",
//     "MRP Message",
//     "Rescheduling date",
//     "Open Qty",
//     "PO Value USD",
//     "Schedule Line",
//     "Delivery date",
//     "Receipt Date",
//     "Net Price",
//     Currency,
//     "Net Price USD",
//     "Plant Name",
//     "Purchasing Group Name",
//     "MRP Controller Name",
//     "MRP Controller"
// FROM [lib://DataFiles/Inventory Reduction FY24 .xlsx]
// (ooxml, embedded labels, table is Export);


// STORE Table1 into [lib://DataFiles/Historical_Inventory_Reduction_FY24.qvd](qvd);

Any ideas or solutions are greatly appreciated

TIA

[marksouzacosta]

Hi @MikeGaunt1 ,

Can you show the error message please? A screen shot will help.

I think you have to adjust your STORE Statement in your first code:

Replace this:

STORE TABLE_HISTORIC into [lib://DataFiles/Inventory Reduction FY24 .xlsx](qvd);

With:

STORE TABLE_HISTORIC into [lib://DataFiles/Inventory Reduction FY24.qvd](qvd);

Qlik does not create XLSX files.

[NenadV]

I think this is because the "MRP Date" field in the qvd file is most likely the date type and in excel is text or similar.I'm not sure, though.

[MikeGaunt1]

Hi Error message is as follows 

"

2:59:49 PM

Output cleared.

2:59:52 PM

---

Started loading data

---

TABLE_HISTORIC << Master_Historical_Inventory_Reduction_FY24

(QVD (row-based) optimized)

Lines fetched: 3,683

---

The following error occurred:

Field 'MRP Date' not found

The error occurred here:

Concatenate LOAD

"MRP Date",

"Part Number",

Description,

"Vendor Number",

Supplier,

"PO/Req/Plnd Order",

Item,

"Order Type*",

"MRP Message",

"Rescheduling date",

"Open Qty",

"PO Value USD",

"Schedule Line",

"Delivery date",

"Receipt Date",

"Net Price",

Currency,

"Net Price USD",

"Plant Name",

"Purchasing Group Name",

"MRP Controller Name",

"MRP Controller",

today() as [load date]

FROM [lib://DataFiles/Inventory Reduction FY24.xlsx]

(ooxml, embedded labels, table is Sheet1)

---

Data has not been loaded. Please correct the error and try loading again."

Thanks

[marksouzacosta]

Great, thank you.

So the problem is in your XLSX file. It is not finding the MRP Date field.
Can you share this Spreadsheet with us?

[MikeGaunt1]

Hi Sure, attached is a small sample

[marksouzacosta]

Everything worked on my side and the code is pretty much the same that you have sent to us:

TABLE_HISTORIC:

LOAD

   "MRP Date",

    "Part Number",

    Description,

    "Vendor Number",

    Supplier,

    "PO/Req/Plnd Order",

    Item,

    "Order Type*",

    "MRP Message",

    "Rescheduling date",

    "Open Qty",

    "PO Value USD",

    "Schedule Line",

    "Delivery date",

    "Receipt Date",

    "Net Price",

    Currency,

    "Net Price USD",

    "Plant Name",

    "Purchasing Group Name",

    "MRP Controller Name",

    "MRP Controller"

FROM

[lib://DataFiles/Historical_Inventory_Reduction_FY24.qvd](qvd)

;

CONCATENATE LOAD

    "MRP Date",

    "Part Number",

    Description,

    "Vendor Number",

    Supplier,

    "PO/Req/Plnd Order",

    Item,

    "Order Type*",

    "MRP Message",

    "Rescheduling date",

    "Open Qty",

    "PO Value USD",

    "Schedule Line",

    "Delivery date",

    "Receipt Date",

    "Net Price",

    Currency,

    "Net Price USD",

    "Plant Name",

    "Purchasing Group Name",

    "MRP Controller Name",

    "MRP Controller",

    Today() AS [Load Date]

FROM [lib://DataFiles/Sample for QLIK com.xlsx]

(ooxml, embedded labels, table is Sheet1);

I'm inclined to think that you have something wrong with your Spreadsheet.

You can try to things:
1 - Use Qlik Load Wizard to get the data from the XSLX file - you must see some preview data like the screen shot below:

2 - Re-upload your XLSX file (just in case something was corrupted)