Spectre Flow Join Process Object

The Spectre Flow Join Process object allows you to add more data to your main data flow before building an output.

The Join Process object has four sections in the properties panel where you set attributes.

Spectre Flow Join Process Node Properties

You set attributes for the Join Process object in the Closedobject attributes section.

Attribute Description
Join Type

Determines the type of join that is performed. The join types in the Join Process object closely match the join types used in classical relational database logic. The following join types are supported:

  • inner—Only rows that have matching join columns in both input flows are returned in the output flow. If a flow has duplicate rows with the same join column values, then a cartesian product of the matching rows is returned in the output flow. If a column exists in both flows, its "left" flow values are kept.
  • outer—All rows are returned in the output flow. If a row in one flow does not have a match in the other flow, then it is matched with a row of blank values. As with the inner join, a cartesian product is returned for duplicate rows when present in both flows.
  • left outer—All rows from the first (left) flow are returned. If the join column values for a row in the left flow do not match the join column values for any row in the right flow, those values are matched with a row of blank values for right flow columns. If a flow has duplicate rows with the same join column values, then a cartesian product of the matching rows is returned in the output flow.
  • right outer—All rows from the second (right) flow are returned. If the join column values for a row in the right flow do not match the join column values for any row in the left flow, those values are matched with a row of blank values for left flow columns. If a flow has duplicate rows with the same join column values, then a cartesian product of the matching rows is returned in the output flow.

For information about the flow script tag, see join-type.
Keep all left columns If true, any left side columns not specified with the Left Column attribute are included in the output. For information about the flow script tag, see include-other-left-columns.
Keep all right columns If true, any right side columns not specified with the Join With attribute are included in the output. For information about the flow script tag, see include-other-right-columns.
Left Column Specifies a column that contains values from the left column grid for joining. For information about the flow script tag, see left-column.
Join With Specifies a column that contains values from the right column grid for joining. For information about the flow script tag, see join-column.
Props Opens the Edit [Column] properties window.

Each object has an area where you can enter comments. It is DI best practice to enter a note for every object in a Spectre Flow script.

Every Spectre Flow node comment area is Markdown-enabled. For more information, see Workbench Markdown Editor.

The Join Process object Closedcolumn grid section lists the columns from the input sources. The right and left column grids have the exact same structure.


Attribute Description
Name Displays the name of each input column. This attribute is read-only.
Type Displays the type of each input column. This attribute is read-only.
Keep

Manages which columns are kept in the output data flow.

Select the Keep check box for columns you want to explicitly keep in the output data flow. After marking any column with a Keep check mark, only those marked Keep are kept in the output data flow.

Props Opens the Edit [Column] properties window.