P6 Join Processor - EcoSys - 3.1 - Help - Hexagon

The P6 Join processor is used to combine the entity sets returned from two SOAP calls. When you add the processor, it allows for a single nested Reader to be added to it. You must first add a reader and configure it and then configure the settings for P6 Join Processor.

1. Enter the following parameters in the Basic section:

   1. Input Key Attributes – The key in the previous step entity set that is used to join the data.

   2. Reader Key Attributes – The key in the SOAP readers entity set that is used to join the data.

   For example,

   Input Key Attributes = objectId

   Reader Key Attributes = foreignObjectId

   Previous Step entity set

Reader Entity Set

Result Entity Set

2. Enter the following values in Advanced section (Optional).

1. Reader Selects – Selects the fields to be added from the reader during the Join and allows assigning of an alias.

2. Left Join? – If checked, any row from the previous step that has no matching value from the Reader is kept in the entity set.

Example

If the Reader Selects is only set to location with an alias of ProjectLocation and Left Join is checked, the result entity set would be as follows,

Previous Step Entity Set

Reader Entity Set

Result Entity Set

If Left Join? is not selected, the third row would not be in the result set.