Merge Rows (diff)
Description
Merge Rows (diff) is a step in the Joins Plugin for Process Studio Workflows. Merge rows step compares data from two input streams (say reference and compare rows) and merges the data, based on common keys. The data from both the input steps should be sorted on the key used for merging. The two streams are compared based on keys as well as other fields of the row. The latest version of a row is passed to the next steps. The new rows are flagged as equals, changed, new or deleted as the case may be. (This is useful for comparing data from two different times. It is often used in situations where the reference system does not contain a date of last update).
This step may be used in conjunction with Synchronize after merge step. The flag column is then used to execute updates/inserts/deletes on a target table.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| 2 | Reference rows origin | Specify the step with reference rows. |
| 3 | Compare rows origin | Specify the step with compare rows (new rows). |
| 4 | Flag fieldname | Specify the name of the flag field on the output stream. It will contain one of the following values: Identical, Changed, New or Deleted |
| 5 | Keys to match | Specify fields containing the keys on which to match; click Get key fields to insert all of the fields originating from the reference rows step |
| 6 | Values to compare | Specify fields containing the values to compare; click Get value |
| fields to insert all of the fields from the originating reference and Compare rows steps. Key fields need not be specified here. The Flag fieldname is populated depending on the value in the compare field or the absence of rows for some keys in the compare rows the |