Join Results
The
Join action combines repeating sets of
records from two results based on a relationship that you define between fields in each record.
You define how records are joined with one or more join conditions. You can also define how multiple conditions are used: either all conditions must be matched or at least one must be matched.
This acts somewhat like a join for a database. The results include only those items from the two inputs that match one or more of the join conditions. If a matching item from the first input does not have a matching item from the second input, it is not included, and vice versa.
You must connect two blocks as the input to
Join and define at least one join condition. You can also use the following advanced techniques for
Join:
As of version 3.5, this action block uses a different method to perform joins than in earlier releases. This change has no effect on mashups from earlier releases.
Business Analytics developers who know XPath well can use the
Advanced Mode button to customize the XPath expressions for conditions. Use the advance mode with care, however, as it disables the display of conditions in basic mode. If you return the condition to basic mode, your customized XPath expression for the condition is lost.
apply option | If there are two or more join conditions, set this option to determine whether only one condition is sufficient to ensure a join or all conditions must be met. |
join condition | Each join condition has a left- and right-field and a relationship operator: operator: select the relationship operator for this join condition. |
Case Sensitive | Set this option if this join condition should be case sensitive. |
Add Condition | Use this button to add more join conditions. |
Customize Output | Set this options if you need to add or delete fields from the joined record or apply functions to the data in fields. See Fine Tune the Joined Result for instructions. |