Join Results

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:

With

Join blocks created in version 3.5 or later, you can also Fine Tune the Joined Result.

Presto 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: left-field: click in this field to select the field from one result that should be used to define this join condition. See Select Fields or Paths for Block Properties with the Path Selector for more information. operator: select the relationship operator for this join condition. right-field: click in this field to select the field from the remaining result that should be used to define this join condition. See Select Fields or Paths for Block Properties with the Path Selector for more information.
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.