Independently of the result option, the result table contains
- all columns of the input table in their order,
- all columns of the interval table in their order,
- one DateTime column "Result From", and
- one DateTime column " Result To"
in this order.
The value of the parameter "Result" decides which rows of the input table are contained in the result table, with which rows of the interval table they are combined, and the information shown in the "Result From" and "Result To" columns.
These option computes the intervals and parts of intervals where data from the input table and data from the interval table overlap.
The result table contains one row for each overlap between the input intervals and the intervals of the interval table.
It contains more than one row for one input interval, if this interval overlaps with more than one interval of the interval table.
However, if an input interval overlaps with more than one interval of the interval table and these intervals of the interval tables have the same "From" time and the same "To" time, then only the overlap with the first interval, with respect to the ordering of the rows in the interval table, is contained in the result table.
The result table copies all fields of the respective row in the input table and all fields of the row in the interval table that contains the interval it overlaps with. The "Result From" and "Result To" columns contain the start time and the end time, respectively, of the overlap.
See also "Overlapping intervals" in the classification of interval relations above. Table below shows result table of data node C02 of project file.
![](_scroll_external/attachments/93822fa9234b/example-overlapping-first.png)
These option computes the intervals and parts of intervals where data from the input table and data from the interval table overlap.
The result table contains one row for each overlap between the input intervals and the intervals of the interval table.
It contains more than one row for one input interval, if this interval overlaps with more than one interval of the interval table, regardless of the double intervals having the same "From" and "To" times (this is the difference to the option Overlapping (first)).
The result table copies all fields of the respective row in the input table and all fields of the row in the interval table that contains the interval it overlaps with. The "Result From" and "Result To" columns contain the start time and the end time, respectively, of the overlap.
See also "Overlapping intervals" in the classification of interval relations above. Table below shows result table of data node C03 of project file. Note row 2 of this table, which is not included in the table computed with option "Overlapping (first)" above.
![](_scroll_external/attachments/5bcd062e5a55/example-overlapping-all.png)
This option computes the intervals and parts of intervals of the interval table not overlapped by intervals of the input table. It considers for each entry in the input table all intervals valid for that day.
The result table contains one row for each input interval and interval of the interval table valid for the respective day and not at all or not completely overlapped by the input interval. It hence contains more than one row for one input interval if there is more than one interval in the interval table valid on the day which the input interval does not overlap.
The result table copies all fields of the respective rows of both the input table and the interval table. The "Result From" and "Result To" columns contain the start time and the end time, respectively, of the (part of the) interval that is not overlapped by the input data on the respective day.
See also "Missing intervals" in the classification of interval relations above. Table below shows result table of data node C04 of project file.
![](_scroll_external/attachments/ba6553ad1a0a/example-missing-by-row.png)
This option computes intervals and parts of intervals of the interval table not overlapped by intervals of the input table, like option "Missing intervals (view by row). The difference is that it considers for each day between and including the earliest and the latest day of the input table each interval valid on that day.
The result table contains one row for each interval of the interval table for each day for which it is valid between the earliest and the latest day of the input table where it is not completely covered by an interval of the input table.
The result table fills all fields of the input table with "-" and copies those of the interval table. The "Result From" and "Result To" columns contain the start time and the end time, respectively, of the (part of the) interval that is not overlapped by the input interval on the respective day.
See also "Missing intervals" in the classification of interval relations above. Table below shows result table of data node C05 of project file.
![](_scroll_external/attachments/f9ec231495cd/example-missing-all.png)
This option computes intervals of the input table not overlapped by intervals of the interval table (the inverse of option "Missing intervals (view by row)").
The result table contains one row for each input interval that is not fully overlapped by an interval of the interval table. It hence contains at most one row for each row of the input table. It copies the rows of the input table and fills all fields of the interval table with "-". The "Result From" and "Result To" columns contain the start time and the end time, respectively, of the (part of the) input interval not overlapped by an interval of the interval table.
See also "Times not included in intervals" in the classification of interval relations above. Table below shows result table of data node C06 of project file.
![](_scroll_external/attachments/568cd11a074b/example-times-not-included.png)
This option considers each row of the input intervals and classifies its interval according to the classifications described above ("Classification of interval relations").
The result table contains one row for each input interval and its classification(s). Hence, if an input interval falls into more than one classification, then the result table contains more than one row for this interval. The "Result From" and "Result To" columns contain the start and the end time of different intervals depending on its classification:
- Overlapping intervals (Überlappende Intervalle): Start time and end time of the overlap inside the interval of the interval table.
- Missing intervals (Fehlende Intervalle): Start time and end time of the non-overlap inside the interval of the interval table.
- Times not included in intervals (Zeiten kommen in Intervallen nicht vor): Start time and end time of the non-overlap inside the input interval.
Table below shows result table of data node C07 of project file.
![](_scroll_external/attachments/09985bbbf520/example-classification-times.png)