Table of Contents

Search

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

Data Validation Option User Guide

Data Validation Option User Guide

Generating Tests for a Single-Table Constraint from a Spreadsheet

Generating Tests for a Single-Table Constraint from a Spreadsheet

Data Validation Option can generate single-table tests based on test definitions in a spreadsheet. To generate the tests, export the existing tests, add tests to the spreadsheet, and then import the tests from the spreadsheet into Data Validation Option.
  1. In the Navigator, right-click the single table and select
    Export Tests to Spreadsheet
    .
    The
    Save As
    dialog box appears.
  2. Save the spreadsheet to a location that the Data Validation Client can access.
  3. Open the spreadsheet.
    The spreadsheet shows the existing single-table constraint test definitions if tests exist.
    The Excel spreadsheet shows a test defined for a single table. The spreadsheet shows the following test properties: test function, field, expression, datatype, precision, scale, operator, and constraint value.
  4. Add tests for the single table.
    Verify that the content in the spreadsheet meets the spreadsheet requirements.
  5. Save and close the spreadsheet file.
  6. In the Navigator, right-click the single table and click
    Generate Tests from Spreadsheet
    .
    The
    Generate Tests
    dialog box appears.
  7. Click
    Browse
    and select the spreadsheet.
    A message specifies how many tests are imported.
  8. Click
    OK
    .
    The
    Generate Tests
    dialog box previews the tests to be generated and shows any errors. A red circle icon indicates that the row has an error. A yellow triangle icon next to a cell indicates that the value of the cell has an error.
  9. If a test has an error, select the test row with the error to preview the error.
    The error appears at the bottom of the
    Generate Tests
    dialog box.
    The dialog box shows the name and location of the spreadsheet file, test definitions, and an error.
  10. Resolve the error or remove the test.
  11. To change a test property, select the property in the
    Generate Tests
    dialog box and then make the change.
  12. To remove a test, select the test row and click
    Remove
    .
  13. To add a test, click
    Add
    and enter the test properties.
  14. Click
    Save
    to import the tests.