Join Types in Mapping Step
- 17 Mar 2023
- 2 Minutes to read
- Print
- DarkLight
Join Types in Mapping Step
- Updated on 17 Mar 2023
- 2 Minutes to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
| Step Details | |
| Introduced in Version | 8.10 |
| Last Modified in Version | 8.10 |
| Location | Data > List |
The Join Types List Mapping step combines two lists of objects with different data types into a single list.
The step will output all objects from the first list, and only matched objects from the second list will be used as the result set.
The joined results are outputted to the selected Output Type for the step, where properties from each list can be mapped using the Item Mapping Editor found on the step.
Properties
Data
| Property | Description | Data Type |
|---|---|---|
| Input Data Type A | The datatype for the first inputted list | Determined by the selected datatype from the list |
| Input Data Type B | The datatype for the second inputted list | Determined by the selected datatype from the list |
| Input Type Match Property A | The field or property from the datatype that will be used to match items between the lists | Determined by the selected datatype from the list |
| Input Type Match Property B | The field or property from the datatype that will be used to match items between the lists | Determined by the selected datatype from the list |
| Output Type | The output type is used to display the result set. The properties from the result set will need to be mapped using the Show Item Mapping Editor. Selecting this will open the Item Mapping editor for the step. | Determined by the selected datatype from the list |
Join Match Behavior
| Property | Description | Data Type |
|---|---|---|
| MultipleMatchesCauseError | If enabled, this will cause the step to throw an error if multiple matches are found | Boolean |
Inputs
| Property | Description | Data Type |
|---|---|---|
| List of A | The list of objects used as the first input list. All objects from this list will be returned in the result set | Determined by the type selected for Input Data Type A |
| List of B | The list of objects that will be joined to the first list. Only objects with matching properties will be returned in the result set. | Determined by the type selected for Input Data Type A |
Outputs
| Property | Description | Data Type |
|---|---|---|
| Outputs | The datatype used to display the result set. Properties from either field can be mapped to the new datatype. | Determined by the type selected for Output Type |
Example Inputs and Outputs
| List of A | List of B | Output Type | Output |
|---|---|---|---|
| List of Accounts | List of Assignments | A datatype that contains values from List A and B | Returns a list of Accounts and the first matching Assignment |
| Null List | List of Accounts | A datatype outputting values from List A and B | Returns a Null List |
| List of Accounts | Null List | A datatype that outputs values from List A and B | Returns a list of Accounts and outputs null for values from List B |
Common Errors
Outputted List is Null
This can occur if the properties for the output datatype are not mapped correctly to a property from List A or B. Ensure that properties are mapped correctly in the Item Mapping Editor.
Was this article helpful?
