Files

Use the Files tab to select up to five data files used to extract the data that appears on the data miner report.

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

The fields on the Files tab are:

Field	Description
Description	A brief description of the file. If the file is an iSeries file, the description displays the query name, the name of the user who created the query, and the name of the file associated with the query. Joined files have an indented file description.
File	The data file from where the data is 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 the field name link to open the Select Join screen.
Type of Join	Displays how the records in each of the secondary files are used for the report based on the records of the primary file. See the join type table below.
Add Join	Add additional files to the report using the Add File screen. N/A is displayed in this field once five files have been selected for the report.
Delete	Deletes the selected file from the report query.

The available join types are:

Type	Description
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. If the secondary file has no records that match records in the primary file, then the system uses 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. If the secondary file has no records that match records in the primary file, then the system uses 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 allow you to specify a secondary file.

Click Close to close the Files tab and return to the Data Miner screen.

Revision: 2026.01