Advanced Mapping via Graphical Editor

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Yes, this can be done using advanced user-function in message mapping, where you have to examine the contexts of both messages. This requires some java coding and can not be easily described here.

As in the previous reply XSLT mapping is easier to do for this case.

Regards,

Bill

[Former Member · Accepted solution]

Frank and Bill,

Thanks guys for your help. We were able to solve this using XSLT.

But, I'm a little worried because of the size of messages we will be processing. Can you guys provide some details on using java to define relationships or just point me to where I can find further info?

By the way Stylus Studio was a tremendous help.

Thanks for your help.

Best Regards,

Doo

[Former Member · Accepted solution]

Hi Duke,

What you do with the userdefined functions is:

• determine how many items and context changes every field has in its queue.

*if one of the fields has less items or context changes in its queue, create these items or context changes, so all fields are in sync.

Post your email address I will send you a document, where it is explained together with some sample code.

Cheers,

Frank

[Former Member · Accepted solution]

Hi Frank,

My email address is dooykim2003@yahoo.com.

Thanks for your help.

Best Regards,

Duke

[moorthy · Accepted solution]

Hi Frank,

I am having similar scenario.

Pls send me the document to this email: moorthy_kp@yahoo.com.

Thanks in advance,

Moorthy

[Former Member · Accepted solution]

Hi Duke,

How did you do the 2:1 XSLT mapping inside the ccBPM? We tried to

merge two different xml messages into another one but could

not get it work inside BPM.

Could you please email me an example xslt stylesheet file?

My email is simonxhu@yahoo.com.

Thanks much.

-Simon

[Former Member]

Hi Doo,

We had the same problem and solved it in two different ways:

- establish relationship with java user defined functions in the graphical XI mapping

- xslt mappings.

We finally choose XSLT mappings, because it is much easier to build and maintain. The only thing you have to be aware of is: don't use XSLT with large messages.

Cheers,

Frank

PS a good visual XSLT mapper is Stylus Studio