Loading country speciffic holidays into NetWorkDays

Posb1 — Fri, 07 Jan 2022 13:20:52 GMT

Hello,

To calculate delivery times I need to use NetWorkDays with a list of holidays that differs based on the country. I have the following script:

//loading all shipments

tempLeadTime:

LOAD

shipmentNumber,

Customer,

dateShipmentCreated

FROM [...Shipment.qvd] (qvd);

//adding loading date

LEFT JOIN (tempLeadTime)

LOAD

shipmentNumber,

loadingDate

FROM [...loading.qvd] (qvd);

//adding delivery date and country

LEFT JOIN (tempLeadTime)

LOAD

shipmentNumber,

deliveryDate

countryCode

FROM [...delivery.qvd] (qvd);

I have a table available in the script containing countries and a list of holidays formatted like the variable I normally use to insert a list of holidays into NetWorkDays.

An example selection:

AT	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44567','44666','44682','44696','44788','44860','44866','44867'
BE	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44682','44763','44788','44866','44876'
BG	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44623','44675','44676','44682','44810','44826','44866'
CH	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44567','44666','44774','44788','44866','44867'
CZ	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44666','44682','44689','44747','44748','44862','44882'
DE	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44567','44666','44682','44728','44788','44837','44865','44866'

How can I insert the right list of holidays into the NetWorkDays to get a realistic leadtimes based on country specific holidays?

topic Re: Loading country speciffic holidays into NetWorkDays in App Development

Loading country speciffic holidays into NetWorkDays

Re: Loading country speciffic holidays into NetWorkDays

Re: Loading country speciffic holidays into NetWorkDays