Join two inputs without a key

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

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.