message mapping problem

[Former Member]

hi

[former_member200962 · Accepted solution]

whats the problem??

[Former Member · Accepted solution]

hi

I have a source structure like below

message1 1:1

records 0 to unbound

field1 0 :1

field2 0 :1

subrecords 0 to unbound

field3 0:1

field4 0 :1

target structure is an RFC message strcuture like this

y_rfc 1:1

data 1:1

item 0 to unbound

field1

field2

field3

field4

now for every node subrecords there should be one records item. this i have achieved by the below ,mapping logic for field1 and field2

fiedl1----

---

>

subrecords -

---

> useoneasmany-----> field1

subrecords > splitbyvalue->

similarly fir field2. for field3 and field4 it is direct mapping.

by this mapping what happens is if there are 3 subrecords nodes in a source message then the target structure will contain 3 item records where the field1 and fields are repeated. this is working fine.

Now the problem is if i have 3 record nodes which have 1, 2 and 3 subrecord nodes then i want to have total 6 item nodes in the structure. how do i achieve this?

right now i have mapped item with records node.

thanks

Edited by: sudhakar murthy on Jun 14, 2009 11:10 AM

Edited by: sudhakar murthy on Jun 14, 2009 11:23 AM

Edited by: sudhakar murthy on Jun 14, 2009 11:23 AM

[former_member200962 · Accepted solution]

Now the problem is if i have 3 record nodes which have 1, 2 and 3 subrecord nodes then i want to 
have total 6 item nodes in the structure. how do i achieve this?

I think the count should be 9 (and not 6 as mentioned)...1-Record = 3-Subnodes ..... so 3-Record = 9-Subnodes....please correct if i am missing something...

right now i have mapped item with records node.

map the Subrecord node to Item...just raise the Context of the Subrecord node to the node above Record....i.e. to message-level....just tested this and able to get 9 Item nodes for 3-Record nodes on source side (each having 3 Subnodes)

Regards,

Abhishek.

EOD.