The Merge rows (diff) step contains the following options.
| Option | Description |
|---|---|
| Reference rows origin | From the drop-down list, select the input source for the original reference rows you want to compare. The input source will be a previous step in the transformation. |
| Compare rows origin | From the drop-down list, select the input source for the compare rows. The input source will be a previous step in the transformation. |
| Flag fieldname | Specify a field name that will contain the flag indicating how the values were compared and merged in the output row. |
| Keys to match | Specify the field names that contain the keys on which to generate a match. |
| Values to compare | Specify the field names that contain the values on which to generate a comparison. |
| Get key fields | Click the Get key fields button to populate the Keys to match table with all the fields in the Reference rows origin step. |
| Get value fields | Click the Get value fields button to populate the Values to compare table with all the fields in the Compare rows origin step. |