Getting Field not found when doing concatinate with qvd file

[Bjarte]

Hi

I am getting the error:

"

The following error occurred:

Field 'CleaningId' not found

The error occurred here:

Concatenate load CleaningId, Hotel, "Work day", Room, "Routine name", "Assigned to", "Task name", "Work status", Credits, Priority, Name, "Setting condition", "Unit type", "Checkpoint count", "Done count", "Unset count", "Skipped count", "Problem count", "In progress", Stay from [lib://Office_365_Sharepoint - bjarte.karlsen@ability.no/Shared Documents/QVDFiles/HouseKeeping Work Group Data.QVD]"

However I have tested a normal load form the QVD file and I am sure this CleaningId field is there.  In fact I took a copy of the fields from a load statement.  Here is the whole script:

Cleaning:
LOAD
RowNo() as CleaningId,
'Radisson Royal Garden' as Hotel,
"Work day",
"Room/Common area" as Room,
"Routine name",
"Assigned to",
"Task name",
"Work status",
Credits,
Priority,
Name,
"Setting condition",
"Unit type",
"Checkpoint count",
"Done count",
"Unset count",
"Skipped count",
"Problem count",
"In progress",
if("Work status" <> 'delay' and WildMatch("Setting condition", '*stay*'), 1,0) as Stay
FROM [lib://Office_365_Sharepoint - bjarte.karlsen@ability.no/Shared Documents/Hotelkit Downloads/RadissonRoyalGardenTrondheim/Work Group Report.xlsx]
(ooxml, embedded labels, table is [Housekeeping-Report]);

Concatenate
load CleaningId,
Hotel,
"Work day",
Room,
"Routine name",
"Assigned to",
"Task name",
"Work status",
Credits,
Priority,
Name,
"Setting condition",
"Unit type",
"Checkpoint count",
"Done count",
"Unset count",
"Skipped count",
"Problem count",
"In progress",
Stay
from [lib://Office_365_Sharepoint - bjarte.karlsen@ability.no/Shared Documents/QVDFiles/HouseKeeping Work Group Data.QVD];

Store Cleaning into [lib://Office_365_Sharepoint - bjarte.karlsen@ability.no/Shared Documents/QVDFiles/HouseKeeping Work Group Data.QVD];

// LOAD
// CleaningId,
// Hotel,
// "Work day",
// Room,
// "Routine name",
// "Assigned to",
// "Task name",
// "Work status",
// Credits,
// Priority,
// Name,
// "Setting condition",
// "Unit type",
// "Checkpoint count",
// "Done count",
// "Unset count",
// "Skipped count",
// "Problem count",
// "In progress",
// Stay,
// [<?xml version="1.0" encoding="UTF-8" standalone="yes"?>]
// FROM [lib://Office_365_Sharepoint - bjarte.karlsen@ability.no/Shared Documents/QVDFiles/HouseKeeping Work Group Data.QVD]
// (qvd);

[Or]

Perhaps the issue is with the missing (qvd) at the end of the FROM?

[Bjarte]

Can you point me to which statement.  I copied the filepath from a working load from that qvd

[Or · Accepted solution]

from [lib://Office_365_Sharepoint - bjarte.karlsen@ability.no/Shared Documents/QVDFiles/HouseKeeping Work Group Data.QVD];

vs

// FROM [lib://Office_365_Sharepoint - bjarte.karlsen@ability.no/Shared Documents/QVDFiles/HouseKeeping Work Group Data.QVD]
// (qvd);

[Bjarte]

Hi.  That bottom part you are referring to is commented out and not in use. 

[Bjarte]

Ah.  You are right.  Thank you 🙂