Summary

Merge rows of the current result table with rows of another data node's result table based on a relation between time intervals of the two tables, such as overlapping intervals or same intervals. Requires a two columns of data type DateTime in each of the two tables.

The result table of this operator can contain only intersecting rows or intersection rows together with rows from the either of the input tables.

Configuration

Settings

(Setting name of previous version in non-bold letters.)

Name

Value

Opt.

Description

Start date/time in current data node

From column

System.String


Column that contains the start times of the intervals in the current data node.

End date/time in current data node

To column

System.String


Column that contains the end times of the intervals in the current data node.

Identifier columns current data node

Additional columns from data source

System.String

opt.

Condition to be fulfilled in order to merge row of current data node with row of incoming data node

Incoming data node

Data source



Data node to merge with the current data node.

Start date/time in incoming data node

From column data source

System.String


Column that contains the start times of the intervals in the incoming data node.

End date/time in incoming data node

To column data source

System.String


Column that contains the end times of the intervals in the incoming data node.

Identifier columns incoming data node

Additional columns from data source

System.String

opt.

Identifier columns of the incoming data node to compare to identifier columns of the current data node. Number and data types must match the columns selected in "Identifier columns current data node".

Interval condition

Time relation

System.String

  • Intervals are identical
  • Intervals are overlapping
  • Interval 1 includes interval 2
  • Interval 2 includes interval 1
  • Identical interval start
  • Identical interval end


Condition to be fulfilled in order to merge row of current data node with row of incoming data node

Date/time comparison

Mode from data/time comparison

System.String

  • Compare date and time proportion
  • Compare time proportion only
  • Compare time only, 00:00 in "To" column means 24:00
  • Compare date proportion only
  • Compare hour only
  • Compare weekday only


Options to compare the timestamps in the start and end date/time columns.

Mode

How should the data be merged?

System.String

  • Intersection (same keys)
  • Add to rows from data node 1
  • Add to rows from data node 2


The mode defines which rows from the two data nodes are contained in the result table.

Want to learn more?

Examples

Example: Combine two tables using "Identical interval start"

The following tables should be merged.

A01

  

A02

Settings

 

Result

In case of row No.4 the "DateTimeBegin" did not match so this row was not merged. 

Project File

-


Troubleshooting

Nothing known up to now.

Related topics