Straight Compare Identical Schema
Overview
The Straight Compare Identical Schema macro compares all fields of two inputs positionally, record-by-record. The inputs must have identical schemas and record counts, or the macro fails with an error message. The output contains one entry for each row-cell whose values differs on the left and right sides. Optionally, you may include up to five input fields that are appended on output. For example, if you are comparing the results of address standardization, it is useful to include the ADDRESS, CITY, STATE, and ZIP fields from the input to give the comparison results some context.
Straight Compare Identical Schema macro configuration parameters
The Straight Compare Identical Schema macro has a single set of optional configuration parameters.
Parameter | Description |
|---|---|
Attach field1...Attach field5 | Optional input fields to append on output.
|
Configure the Straight Compare Identical Schema macro
Select the Straight Compare Identical Schema icon.
Go to the Configuration tab on the Properties pane.
Optionally, select Attach field1 and choose input fields to append to output. You may specify up to five input fields.
Optionally, go to the Execution tab, and then set Web service options.