DataFlux Data Management Studio 2.6: User Guide

Data Joining Node

You can add a Data Joining node to a data job to combine two data sets so that the records of one, the other, or both data sets are used as the basis for the resulting data set. The data joining process is similar to SQL joins. Once you have added the node, you can double-click it to open its properties dialog. The properties dialog includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the input.

The Join type section of the dialog includes the following elements:

Inner - Specifies an inner join.

Left - Specifies a left join.

Right - Specifies a right join.

Full - Specifies a full join.

You have the option to load one of the data sources in memory when you perform a join step. The Memory load option section of the dialog includes the following elements:

None - Does not store any of the tables in memory.

Left Table - Stores the left table in memory.

Right Table - Stores the right table in memory.

The Conditions section of the dialog includes the following elements:

Left Table/Right Table - Displays all available fields from each corresponding data set. Select at least one field from the left table and one field from the right table to use as the basis for matching records. After you select each pair of fields, click the blue arrow to add the relationship to the Expressions list. Each new expression is added to the end of the list.

Expressions - Displays the relationships you have selected. You can create more complex matching expressions by using the Or button. Use the up and down arrows to rearrange existing expressions.

The Output fields section of the dialog includes the following elements:

Available - Displays the fields that you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.

Selected - Displays the fields that will be made available to the next node in your data job.

You can access the following advanced properties by right-clicking the Data Joining node:

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_PFUtil_DataJoin.html