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

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
    .