WebFOCUS Online Help > Managed Reporting End User > Creating a Graph With Graph Assistant > Working With Joins
How to: |
A join is a temporary connection between two or more data sources that share at least one common field. Once you join two data sources, each time WebFOCUS retrieves a record from the first data source (host file), it also retrieves the matching records from the second data source (target file).
You use the Join tool to link data sources in both Report Assistant and Graph Assistant. The Join tool provides a graphical method for creating and manipulating joins. You can also create define-based joins and multi-field joins.
When you access the Join tool, the window displays a field list for the host data source (which you specified when you created the Standard Report or Reporting Object), and a field list for any target data source you add to the window.
Important:
The WebFOCUS masters list dialog box opens where you select a target data source.
The following image shows the Join settings window where you select fields from the Host field and the Target field lists to create a join.
or
Press Alt+T to go to the Target Fields list. Tab to the field and press Enter to add the chosen field to the Selected Fields box.
Note: Fields must have the same format and be indexed fields in order to use them to create joins.
The new join appears in the Joins list.
The WebFOCUS masters list dialog box opens where you select a target data source.
The following image shows the list of Define field options.
The following image shows the Define field creator dialog box where you create the Define expression.
Note: Fields must have the same format and be indexed fields in order to use them to create joins.
The WebFOCUS masters list dialog box opens where you select a target data source.
The new join appears in the Joins list.
WebFOCUS |