How to create n nodes from m target nodes?

[Former Member]

Hi,

back to mapping...

A message provides such content:

<Message>

<main>

  ₁₂₃₄

  <low>ABC</low>

</main>

<main>

  ₁₂₃₄

<low>ABC</low>

</main>

<main>

  ₃₄₅₆

<low>BCD</low>

</main>

<main>

  ₃₄₅₆

<low>BCD</low>

</main>

<main>

  ₃₄₅₆

<low>BCM</low>

</main>

</Message>

For each <sub>/<low> combination I need to create one target node....

<Message2>

<target>

<value>1234</value>

  <low>ABC</low>

</target>

<target>

<value>3456</value>

<low>BCD</low>

</target>

<target>

<value>3456</value>

<low>BCM</low>

</target>

</Message2>

Maybe this is too simple but I am stuck......

Your help is welcome....

Regards

Dirk

[Former Member · Accepted solution]

Hi,

Sub

--------concat----removecontext---splitbyvalue(value change)---collapsecontext----target

Low

For the fields u can use below mapping:

Thanks

Amit Srivastava

[Former Member]

Hi,

thank you!

It works with this:

concat -> remove Context -> splitByValue(Value Change) -> collapseContexts -> target

It was the added <sort> that killed me.

Regards

Dirk

[former_member184681]

Dear Dirk,

For the subnodes and fields, you could try using somehow similar logic, together with sortByKey function. I mean, your fields could be sorted by the results of:

X = value (context: Message), low (context: Message) -> concat (separator ":") -> sort -> splitByValue(Value Change)

So use this sort of mapping:

field1 -> sortByKey (X) -> target1

Regards,

Greg

[former_member184681]

Hi Dirk,

The concat function could be a solution for you:

value (context: Message), low (context: Message) -> concat (separator ":") -> sort -> splitByValue(Value Change) -> removeContexts -> target

Regards,

Greg

[gagandeep_batra]

Hi Dirk,

So Sub and low  field is your key field so first concate them then use the following logic which is describe in following thread

http://scn.sap.com/thread/3190674

Regards

Gagandeep