Mashups in Presto Wires : Creating Mashups in Wires : Add Actions or Other Blocks : Join Results
Join Results
 
Fine Tune the Joined Result
Upgrading Mashups with Join Blocks from Previous Versions
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:
*With Join blocks created in version 3.5 or later, you can also Fine Tune the Joined Result.
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.
If you wish to find tune fields and values for the joined result in mashups from earlier releases, see Upgrading Mashups with Join Blocks from Previous Versions for instructions.
*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.
Copyright © 2013-2015 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback