DataFlux Data Management Studio 2.5: User Guide

Data Union Node

You can add a Data Union node to a data job to combine all of the data from two data sets. Like an SQL union join, the Data Union node simply adds the two data sets together; the resulting data set contains one record for each record in each of the original data sets. 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 Mapping section of the dialog includes the following elements:

Left Table/Right Table - Lists all available fields from each corresponding data set. To specify that corresponding values from each table be put into the same fields, select each field in the Left table and Right table lists, and click the center arrow button. For fields that do not correspond, click on the field name in either list and click the down arrow.

Suggest - Matches all field names from the Left table with all field names from the Right table, whether any item is selected from any of the two tables. The match can be case sensitive or case insensitive. (The default behavior is case-sensitive.) To make the match case-insensitive, check the Perform case insensitive comparisons in the Options dialog. The ordinal position of the field is irrelevant, as long as a name matches on both the left and right sides.

Options - Enables you to access the Options dialog for the Data Union node.

The Output Fields section contains the fields selected for inclusion in the data union results and how the fields correspond between the tables. These fields are made available to the next step in your data job. If desired, click in the Output Name fields to edit the names of any fields for the next step. Click the up and down arrows to change the order of the selected fields. You can also click Delete to remove fields from the Output Fields list.

You can also access the following advanced properties by right-clicking the Data Union node in the data job:

• ALTERNATE
• FIELDS