Spectre Flow Merge Process Object
The Spectre Flow Merge Process object merges two tables into one, updating values in the first table ("old source") with values in the second table ("new source") where key values match or adding new rows from the second table.
The Merge Process object has four sections in the properties panel where you set attributes.
Key Columns
Key columns are columns with like values or structure that help Spectre merge the two data flows. The Key Columns section is where key columns are added, modified, and deleted. For information about the flow script tag, see key.
Comments
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.
Column Grids
The Merge Process object column grid section lists the columns from the input data sources. The left and right column grids are structured the same.
| 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. |
| Source Object |
Displays the name of the source object for the column. This attribute is read-only. Double-click the Source Object value for a column to change focus to that object. |