Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've got the following load statement which is throwing me the error: Field '%Date_key' not found.
Does anyone know why and how to fix this?
Facts:
NoConcatenate LOAD
%Date_key,
%Incident_key,
%Employee_key,
Type,
FROM
[lib://ITSM/FCT_ITSMUren.qvd]
(qvd)
where year(%Date_key) >= '2014'
and Type = 'Incident';
Left Join LOAD
distinct %Incident_key,
1 AS _Flag_IncidentNieuw
Resident Incident
where match(%Date_key, date(Floor(Incident.SysCreated), 'DD-MM-YYYY'));
Yours sincerely,
Casper Westelaken
This is the correct solution apart from an error in my datasets, which results in this not giving the correct result (luckily this is fixable.)
Thank you very much!
@sunny_talwar
Whilst this does work, this does result in more calculations that need to be done. The other solution is therefore better.
Thank you very much for your help!