Data Load Error

[Pablo_Aimar]

Hi,

Please can anyone help me understand why my script won't load.  The error message Qlik Sense gives me points to a filed as the problem, but I can see this field in the frontend dashboard, so it is clearly loading.  What is wrong with my syntax?  I've attached a screenshot to better illustrate this script.

CONCATENATE(CostValue)
LOAD
Text("Placement ID") as "Placement ID",
// "Date",
Date(Date#("Date",'YYYY-MM-DD'),'DD/MM/YYYY') as Date,
(Sum(Impressions)/1000) * 9.46 as [Cost-Per-Day]
FROM [lib://Output Files/Openreach/GCM/*.qvd] (qvd)
WHERE Match ([Site (DCM)],'crimtan.com','Programmatic Ads - Crimtan Agency') AND MATCH(NotesOne,'Phase1&2')
GROUP BY Date, "Placement ID";

[JuanGerardo · Accepted solution]

Hi,

as you are loading all qvds in that folder (using *.qvd), they are processed one by one, but at least one of them doesn't have the field NotesOne.

This is your problem.

JG

[Pablo_Aimar]

thank-you 🙂