Skip to Content
avatar image
Former Member

Problem mapping 1 row to multiple rows

Hi experts,

I have an inbound message type like this :

<row>

     <key>KEY</key>

     <field1>FIELD1</field1>

     <field2>FIELD2<field2>

     <field3>FIELD3<field3>

</row>

In my outbound mesage type, I want have multiple rows, one row by field, like this :

<row>

     <champ1>KEY</champ1>

     <champ2>1</champ2>     --> constant = 1

     <champ3>FIELD1</champ3>

</row>

<row>

     <champ1>KEY</champ1>

     <champ2>2</champ2>     --> constant = 1

     <champ3>FIELD2</champ3>

</row>

<row>

     <champ1>KEY</champ1>

     <champ2>3</champ2>     --> constant = 1

     <champ3>FIELD3</champ3>

</row>

How can I do this in message mapping ?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jan 08, 2015 at 09:35 AM

    Hello Guz,

    You can use the node function "USE ONE AS MANY".

    In that first parameter you can pass key and in next two parameter you can pass field.

    Hope this will solve your problem

    Regards

    Naveen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 09:41 AM

    Hi Guz,

    Further to what Naveen stated, ensure you select the context properly. This will be one of the inputs in the node function.

    Regards,

    Sriram

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 10:09 AM

    Hi Guz,

    You can directly map the fields accordingly and try....use duplicate subtree option on target side..

    like right click on row and do the duplicate subtree.....let me know still if you face an issue...


    do the mapping one to one...

    Thanks,

    Sreenivas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 10:13 AM

    Hi Guz,

    Your query is not clear, please write it bit clear, please mention the occurrence for row node.

    you mentioned that in discussion name is 1 row to multiple rows but in your query multiple rows to 1 row.

    Thanks,

    Thiru

    Add comment
    10|10000 characters needed characters exceeded