Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. New Features and Behavior Changes
  4. Repositories
  5. XML Data Source
  6. Tests for XML Data Sources
  7. Connections
  8. Expressions
  9. Table Pairs
  10. Tests for Table Pairs
  11. Single-Table Constraints
  12. Tests for Single-Table Constraints
  13. Examples of Tests from Spreadsheets
  14. SQL Views
  15. Lookup Views
  16. Join Views
  17. Aggregate Views
  18. Business Intelligence and Reporting Tools Reports
  19. Dashboards
  20. DVOCmd Command Line Program
  21. Troubleshooting
  22. Datatype Reference
  23. Reporting Views
  24. Metadata Import Syntax
  25. Jasper Reports
  26. Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Spreadsheet Requirements for Table Pair Definitions

Spreadsheet Requirements for Table Pair Definitions

When you run a table comparison, you can generate table pairs based on table-pair definitions in a spreadsheet. Define table pairs in a spreadsheet to generate table pairs for tables that have different names.
Consider the following requirements for the spreadsheet:
  • Create the spreadsheet based on the spreadsheet template in the following Data Validation Option installation directory:
    <Data Validation Option installation directory>\samples\CompareTables-template.xlsx
  • Define table pairs in the first worksheet. Data Validation Option ignores other worksheets in the Excel workbook.
  • The Excel file must have a .xls or .xlsx file extension.
  • You must enter values in the LEFT_TABLE and RIGHT_TABLE columns.
  • The column names are not case sensitive.
  • If you create a joined table pair, you must specify a column name in the Join_A and Join_B columns. To enter an expression for the join field, generate the table pair and then edit the join field in the table pair.
  • You cannot specify an XML file as a table in the spreadsheet.
  • If you import a table pair from a spreadsheet and the table pair is based on the same tables as an existing table pair, Data Validation Option creates a duplicate version of the table pair with the same name.