Summary

Links a date column to a calendar (e.g. Holiday calendar).

Configuration

Name	Value	Opt.	Description	Example
Date column	System.DateTime	-	Column to be linked	-

Name	Value	Opt.	Description	Example
Data source	System.Int32	-	Reference to a data node containing the calendar. It should contain the elements date and description text.	-
Select day type from source	System.Boolean	-	Should day type be selected from data source?	-
Day type description	System.String	opt.	Only valid if 'Select day type from source' was not checked off. If the date to be checked matches with a calendar entry, the text entered here is written into the column for results.	-
Result column	System.String	opt.	Reference (column name), in which the result is entered. If nothing is entered, a new column is added.	-
Column name	System.String	opt.	Description of the new column	-
Sort data	System.Boolean	-	Sorts the data in the date field in ascending order	-

Please carry out the operator Scaling 8.0 before you link to the calendar. Otherwise a raster interval will be created per calendar day type.
XML definitions are available for a quick import of calendars.
Please check if day types shall be taken from the calendar (seldom) or if a certain denomination shall be used (e.g., "Holiday").
In addition to the public holiday calendar there are also some holiday calendars or macros for computing available. (Link in old wiki does not work any more)

Links a date column to a calendar (e.g. Holiday calendar)

Situation	The following data node shall be linked with two calendar nodes. 1. Annual holidays: 2. Annual closing dates of the company:
Step 1	Settings: Create a new column with the column header 'Day type'. If a date of column 'A From' falls on a holiday, the value in the new column is "Holiday".
Result 1	The calendar information is added to the time data above:
Step 2	Now add the calendar information about the closing dates:
Result 2	The calendar with the closing dates is integrated into the column C "Day type": Please note: If a date is already attributed a calendar type (e.g. 1 January) this is not overwritten in step 2. In the example above, "holiday" is entered for 1 January, "closing" is ignored.
Project-File	Confluence Op Link to Calendar.gzip