(DOC) mergerows fixes
introduce **Reference** vs **Compare* early on
make xrefs to 2 recommended transforms
@@ -16,13 +16,13 @@ under the License.
////
:documentationPath: /pipeline/transforms/
:language: en_US
-:description: The Merge Rows (Diff) transform compares and merges data within two rows of data, adding a field indicator for each row.
+:description: The Merge Rows (Diff) transform compares and merges data within two rows of data, adding a flag for each row.
= Merge rows (diff)
== Description
-The Merge Rows (Diff) transform compares and merges data within two rows of data, adding a field indicator for each row.
+The Merge Rows (Diff) transform compares and merges rows between two data streams called **Reference** (previous data) and **Compare** (new data), adding a flag to each row.
This transform is useful for comparing data collected at two different times.
@@ -30,10 +30,10 @@ For example, the source system of your data warehouse might not contain a timest
You could use this transform to compare the two data streams and merge the dates and timestamps in the rows.
-Based on keys for comparison, this transform merges reference rows (previous data) with compare rows (new data) and creates merged output rows.
+Based on key fields and comparison fields, this transform merges reference rows with compare rows and creates merged output rows.
-A flag in the row indicates how the values were compared and merged.
-Flag values include:
+A flag in each row indicates how the values were compared and merged.
+The possible flag values are:
* **identical**: The key was found in both rows, and the compared values are identical.
@@ -43,11 +43,11 @@ Flag values include:
* **deleted**: The key was not found in the compare rows.
-If the row's flag is **identical** or **deleted**, the merged output rows are based on the reference rows.
+If the row's flag is **identical** or **deleted**, the merged output row is based on the reference row.
-For **new** or **changed** rows, the merged output rows are based on the compare rows.
+If the flag is **new** or **changed**, the merged output row is based on the compare row.
-You can also send values from the merged and flagged rows to a subsequent transform in your pipeline, such as the Switch-Case transform or the Synchronize after merge transform.
+You can also send the merged and flagged rows to a subsequent transform in your pipeline, such as xref:pipeline/transforms/switchcase[Switch-Case] or xref:pipeline/transforms/synchronizeaftermerge[Synchronize after merge].
In the subsequent transform, you can use the flag field generated by **Merge rows (diff)** to control updates/inserts/deletes on a target table.
== Options
@@ -56,12 +56,12 @@ In the subsequent transform, you can use the flag field generated by **Merge row
|===
|Option|Description
|Transform name|Name of the transform.
-|Reference rows origin|Specify the transform origin for the reference rows <- Stream with original rows, or rows you want to compare the new rows to.
-|Compare rows origin|Specify the transform origin for the compare rows.<- Stream with new rows
+|Reference rows origin|Specify the transform that produces the reference rows. It's a Stream with original rows (rows that you want to compare the new rows to).
+|Compare rows origin|Specify the transform that produces the compare rows. It's a Stream with new rows
|Flag fieldname|Specify the name of the flag field on the output stream.
-|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 transform
-|Values to compare|Specify fields contaning the values to compare; click Get value fields to insert all of the fields from the originating value rows transform.
-Key fields do not need to be specified here.
+|Keys to match|Specify fields containing the keys on which to match. Click "Get key fields" to insert all of the fields from the reference rows
+|Values to compare|Specify fields contaning the values to compare. Click "Get value fields" to insert all of the fields from the compare rows.
+Key fields do not need to be repeated here.
|===
== Metadata Injection Support
