Table Compare
Description
Table compare is a step in the Utility Plugin for Process Studio Workflows. This step compares the data from two tables (provided they have the same lay-out at-least partially to compare columns). This step finds the differences in the data of the two tables and provides detailed analysis and logs it in output fields
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 connection /Compare connection | Database connections from which the reference/compare table data will come. |
| 3 | Reference schema field / Compare schema field | Specify the field that contains the schema names for the reference/compare table. |
| 4 | Reference table field / Compare table field | Specify the field that contains the actual table names. This means that you could compare two tables with a different name, as long as they have the same column names. |
| 5 | Key fields field | Specify a field that contains a comma separated list of the fields that make up the 'primary' key of the table(s) you are comparing. The primary key is needed because without this information the two tables cannot be correctly joined. |
| 6 | Exclude fields field | Specify the field that contains a comma separated list of columns that you want to exclude from the comparison. E.g. because they exist in the first table, but not in the second. |
| 7 | Number of errors field | Specify the name of the output column that will contain the total number of errors found for the comparison of your tables. |
| 8 | Number of reference table records field | Specify the name of the field that will contain the actual number of records found in the reference table. |
| 9 | Number of compare table records field | Specify the name of the field that will contain the actual number of records found in the compare table. |
| 10 | Number of left join errors field | Specify the name of the field that will contain the number of records that are only present in the reference table. |
| 11 | Number of inner join errors field | Specify the name of the field that will contain the number of records that show a difference between common records. |
| 12 | Number of right join errors field | Specify the name of the field that will contain the number of records that are only present in the compare table. |
| 13 | Error handling key description input field | Specify the output field names that will be used by the error handling of this step to describe the key(s) on which an error occurred. |
| 14 | Error handling reference value input field | Specify the output field names that will be used by the error handling of this step to describe the reference value that caused an error. |
| 15 | Error handling compare value input field | Specify the output field names that will be used by the error handling of this step to describe the compare value that caused an error. |