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