The excel instruction named "Compare Range" allows a user to compare the ranges between two Excel files using SolveXia. This instruction allows comparison of either formulas or values.
In the following example, the header range of an import file will be compared against the header range of a template file :
The following fields will be required to complete to configure this step:
- The source file
- The source range
- The target file
- The target range
- Type of range to be compared
- The desired response from the step if the range happens to be different
Once the step has been configured, save and run.