weird structure to map

[#1]

Hello.

Currently I'm facing a weird structure to map, source is a well defined xml data object but target structure is weirdly de-coupled and I'm not sure how to solve it via message mapping. I was asked to avoid java mapping usage, so I have to try to make it work with message mapping.

Source structure is something like this:

As you can see is a normal well defined xml data object with two header fields acting like a primary key.

Target structure would be:

It is like it was defined as relational tables where struct acts as a header table and substruct is another table referencing struct by the composite primary key. Items are like registries in the tables. I know is weird but it is the requirement.

I have tried several combinations of functions remove context, use one as many and split by value but none of them seems to get the desired result.

Thanks in advance for any help the community can offer.

[Former Member]

By the way, I even tried going deeper by adding another substructure to the substructure, something like sub_substructure and you can map the keys correctly as long as you change the substructure ans sub_substructure context to the root and generating enough contexts in the graphical mapping, something like this:

Context change:

Generating enough contexts: