Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to exclude public holidays and weekends in the bolded calculation below. Can anyone help please?
LOAD
[Holiday Date]
FROM
LOAD
[Issue ID],
[Notification Date],
[Date Issue Identified],
[Notification Date] - [Date Issue Identified] as [Working Days]
FROM
HI please find the solution below.
LOAD
[Holiday Date]
FROM
LOAD
[Issue ID],
[Notification Date],
[Date Issue Identified],
if(not match([Notification Date],[Date Issue Identified]),[Notification Date]) as [Working Days]
FROM
Do you mean below? I tried, it says 'Holiday Date not found'
LOAD
[Holiday Date]
FROM
[source file]
LOAD
[Issue ID],
[Notification Date],
[Date Issue Identified],
if(not match([Notification Date],[Date Issue Identified]),[Holiday Date]) as [Working Days]
FROM
[source file]
Try this if it complains just use not exist([Holiday Date],[Notification Date]) instead of what is below. This should solve all your problems.
LOAD
[Holiday Date]
FROM
LOAD
[Issue ID],
[Notification Date],
[Date Issue Identified],
if(not match([Notification Date],[Date Issue Identified]),[Notification Date]) as [Working Days]
FROM
[source file]
where not exist([Notification Date],[Holiday Date])
Do you mean like below? Seems odd, I have tried to reload, got error
Yes that is what I mean what was your error?
pull the information first then use a resident load when removing holidays
How to do that?
If it's too difficult, I can put it in expression. Thanks.
Hi
It is straight forward.
e.g.
T1
Load
*
from me.qvd(qvd);
noconcatinate
T2
Load
*
resident T1;
drop table T1;