Situation:
How can you have two inputs merge into one output without using a unique
identifier?
Example:
Input 1 has First Name and Last Name
Input 2 has SSN
How do I have the data mapper combine these based off of record number?
SSN, First Name, Last Name
Solution:
You can fulfill this use case by utilizing the position aggregation function. We used the following steps:
1) Created a for each rule on the record node of the target schema based on the record node of the first input schema
2) Created a local variable varRec1Pos and set the value to the position function
3) Created a for each rule with a predicate function to map to the target ssn field
$Input_SSNSchema/Root/Record[position( ) = $varRec1Pos]/ssn
Comments
0 comments
Article is closed for comments.