Developer Transformation Guide

10.4.0
- 10.5.2
- 10.5
- 10.4.1

Back Next

Port Selectors in Join Conditions

You can include port selectors in a join condition. The join condition must reference a port selector from the master group and a port selector from the detail group.

For example, the Joiner transformation has dynamic ports. You might need to compare multiple generated ports in the join condition.

The following image shows the fields in the port selector for the master group:

The Master_Cust_Selector contains has the CustomerID and FullName ports.

The following image shows the fields in the port selector for the detail group:

The Detail_Cust_Selector contains has the CustomerNo and CustFullName ports. These ports have the prefix

Cust

Create the following simple join condition:

The join condition compares each port in the Master_Cust_Selector to the Detail_Cust_Selector. The join condition is:

CustomerID = CustomerNo AND FullName = CustFullName

Each port selector must contain the same number of ports. The ports must be the same type.

If you change the scope of a port selector and a simple type join condition is no longer valid, the Developer tool might switch the condition type to advanced. You can switch the join condition type back to a simple type on the

Join

tab.

Defining a Join Condition

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal