Files

To open the Files tab, click a Query Name on the Data Miner screen.

The Files tab allows you to select up to five data files that will be used to extract the data that appears on the data miner report.

The following fields appear on the Files tab:

Field Description
Description

A brief description of the file.

Note:  If the file is an iSeries file, the description will display the query name, the name of the user who created the query, and the name of the file associated with the query.

Note:  Joined files will have an indented file description.
File

The data file from where the data will be extracted. The file alias precedes the file name.
Library

The library location where the file resides.
Join Field

The name of the field that joins the two selected files. If this field is blank, it denotes a predefined join between the selected file and the primary file.

To change the Join Field selected, click on the field name link to open the Select Join screen.

Type of Join Displays how the records in each of the secondary files will be used for the report based on the records of the primary file; either Matched Records, Matched Records with Primary File, or Unmatched Records with Primary File. See below for more information regarding each join type.
Add Join

Allows you to add additional files to the report using the Add File screen.

Note:  N/A will be displayed in this field once 5 files have been selected for the report.
Delete Deletes the selected file from the report query.

The following is a description of the available join types:

Type Function
Matched Records Selects records with matching records in both joined files. Only using records from each file that has a match with at least one record in the other file.
Matched Records with Primary File

Selects every record in the primary file (the primary file is the first file specified in a query definition) including records from the secondary file.

Note:  If the secondary file has no records that match records in the primary file, then the system will use defined defaults for records in the secondary file (blanks for character fields or zeros for numeric fields).
Unmatched Records with Primary File

Selects all the records in the primary file that do not have a matching record in the secondary file.

Note:  If the secondary file has no records that match records in the primary file, then the system will use defined defaults for records in the secondary file (blanks for character fields or zeros for numeric fields).

Click the Click to add file link to add a data file to the report.

Click the Yes link in the Add Join field to add additional data files to the report.

For details on how to link to PFWTAB, see the Linking to PFWTAB help topic.

Click a join type in the Type of Join field to alter the fields that join the selected files.

Note:  Only files known to VitalEdge will allow you to specify a secondary file.

The following button allows you to complete your work on the Files tab:

Button Function
Close Closes the Files tab and returns to the Data Miner screen.