Skip to Content

Mapping requirement

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.

Thanks,

Ramu.

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 28 at 12:25 PM

    Hello,

    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.

    Add comment
    10|10000 characters needed characters exceeded