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

Adding a Join View

Adding a Join View

You can add a join view to join multiple data sources. You can add a WHERE clause to filter the records from each data source and configure which columns appear in the join view.
  1. Click
    File
    New
    Join View
    .
    The
    Join View Editor
    dialog box appears.
  2. Enter a description for the join view.
  3. Click
    Add
    in the
    Table Definitions
    pane.
    The
    Select Data Source
    dialog box appears.
  4. Select the data source and click
    Select
    .
  5. To edit the table definition, select the table definition and click
    Edit
    .
    You can edit the table definition to specify or change the table alias, connection properties, WHERE clause, and the optimization level. You must edit the table definition to resolve any errors that appear at the bottom of the
    Join View Editor
    dialog box.
  6. To change the order of the data sources, select a data source and click
    Up
    or
    Down
    .
  7. To remove a data source, select the data source and click
    Remove
    .
    When you make any change to the data sources in the join view, you must create the join conditions again.
  8. Click
    Select Output Fields
    .
    The
    Output Fields
    dialog box appears.
  9. Click in the
    Alias
    field to enter a column alias.
  10. In the
    Include as Output Field
    column, select the checkbox for fields that you want to include as output fields of the join view.
  11. To change the order of the fields, select a field and click
    Move Up
    or
    Move Down
    .
  12. Configure join conditions for all the data sources.
    You can join a data source with any of the preceding data sources in the
    Table Definitions
    pane. You need not specify the join condition for the first data source. If applicable, you must create the join condition after you create the column aliases.
  13. Click
    OK
    .