Join Types in Mapistry Workflows Connect Step

In the Mapistry Workflows Connect step, you can choose one of three ways of joining the data from your two data sources outlined below.

Only Include Matching Rows

This is also known as an Inner Join and only returns rows with matching data in both data sources, omitting rows from both sources that do not fulfill the defined condition. 

💡 When connecting a log to a resource you will most likely use this option.

Include all rows

This is also known as a Full Outer Join and returns all the rows of both data sources, merging the matching rows based on the condition defined.

💡 This option would likely be used when connecting two logs based on a matching day, month, or year.

Include all rows in [Data source 1], but only matching rows from [Data source 2]

This is also known as a Left-Outer Join. Based on the condition defined, it returns all the rows from the first data source and all the data from the matching rows of the second data source.

Join Type Example

Let's take for example two logs that are recording the hours of operation of 2 devices in a facility. 

The Operation Hours Log for Device A could look something like this:

While the Operation Hours Log for Device B could be:

Choosing the Only include matching rows option would result in the following table:

Choosing the Include all rows option would result in the following table:

Choosing the Include all rows from [Data source 1] and only matching rows from [Data source 2] option would result in the following table: