Select All Fields

Select: All fields from both sources are included in the output. Duplicate field names are renamed automatically (e.g., Status, Status_1, Status_2).
Clear: Choose specific fields to include by selecting checkboxes next to field names.

Join Type

Select the desired type of join: Inner Join, Left Outer, Right Outer, Full Outer.

Join Conditions

Specifies the join key by mapping fields between the two inputs. The condition is formed by Field Name, Operator, and Field Name.

Union Type

Unsorted or Sorted. Defines whether the output is sorted or unsorted.

Sort Priority

Set sorting priority for fields (1, 2, or 3) to define order of sorting at the field level.

Sort Criteria

Defines sorting order as either Ascending or Descending for the output.

Remove Duplicate Rows

Select: Ensures only distinct rows are included in the output.

Clear: Allows all rows, including duplicates.

Add Column

Adds a new column to the output.

Rename Column

Allows renaming of the selected column.

Delete Column

Removes the selected column.