Join and Union Step

Property

Values

Comments

Select All Fields

Select/De-select

Select = All fields from both the sources will be available in the output of this step

The duplicate field names will be automatically renamed (suffixed with a underscore and number), example: if there is a common field named “Status” in multiple data sources that are joined, the names become Status, Status_1, Status_2, and so on

De-select = You can choose which fields should be available in the output of this step

Choosing is done by selecting the check box adjacent to field names of both inputs

Join Type

Select from:

Inner Join

Left Outer

Right Outer

Full Outer

Select the type of join from the available list

Join Conditions

Field name Operator Field Name

Forms the Join Key

Property

Values

Comments

Union Type

Unsorted

Sorted

The output of this step shall be sorted or not

Sort Priority

Number 1-3

This property is at field level.

This is set below the field name.

Set the number 1, 2 or 3 to the fields which should be sort key

Sort Criteria

Ascending

Descending

Sorting criteria as either ascending or descending order

Remove Duplicate Rows

Select/De-select

Select = To get distinct rows from Union step

Column

Enter

The selected field name populates automatically.

You can change the caption of the resultant field.

You can perform the actions on columns as mentioned in the below table

Action Button

Comments

Add Column 

To add a new column

Rename Column 

To apply typed name to the selected column

Delete Column 

To delete the selected column