Advanced Mapping via Graphical Editor

Hello,

We have a scenario where we need to map contents of 2 messages into one target message matching a specific field in the two messages.

For example:

Message 1 --> Row --> ID(123)

Message 1 --> Row --> ID(456)

Message 2 --> Row --> ID(456) Name(X)

Message 2 --> Row --> ID(123) Name(Y)

Message 2 --> Row --> ID(789) Name(Z)

This needs to map to the target structure with the results

Row --> ID(123) Name(Y)

Row --> ID(456) Name(X)

We are unable to use the ID as the correlation in the BPM due to the fact that within one message the ID can vary.

Can the above be achieved using the graphical mapping in conjuction with BPM?

Or should we look into XSLT ot ABAP mapping.

Any help or suggestions would be greatly appreciated.

Thanks.

Best Regards,

Doo