Join two inputs without a key


How can you have two inputs merge into one output without using a unique


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



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


Have more questions? Submit a request


Article is closed for comments.