Skip to Content

Mapping requirement

Jan 10 at 03:54 PM


avatar image

Hi Experts,

My requirement is as below.

Source structure will look below:

If you observe Address node appears from 0..3 times.

Ideal case should have NationalVersion with occurences of Address nodes like below with AddressTpe NC, NV, NG.

Above NationalVersion has 3 Address nodes with all 3 AddressType NC, NV, NG.

But in some cases NationalVersion will not have all 3 Address nodes in that PI mapping has to create Address node with only AddressType populated remaining all fields with NULL values.

In this case it has 2 Address Nodes NG, NV but no NC.

In this case in target structure should contain one more Address node with AddressType NC.

Some time NationalVersion will not have at least one Address node .

In this case mapping should create 3 Address nodes with only AddressType populated remaining fields should be populated with NULL values in all 3.

Kindly suggest mapping logic.



capture.jpg (97.5 kB)
capture.jpg (35.4 kB)
capture1.jpg (43.5 kB)
capture1.jpg (43.5 kB)
capture3.jpg (26.7 kB)
capture4.jpg (28.4 kB)
capture5.jpg (24.5 kB)
capture7.jpg (24.5 kB)
capture8.jpg (24.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jan Holakovsky Feb 28 at 12:25 PM


I guess the address in the source is optional, than I would simply create 3 addresses in the target structure, and map it from the source 1:1 with IF source empty, put null. That should be easy to implement and should fulfill your request.

10 |10000 characters needed characters left characters exceeded