cancel
Showing results for 
Search instead for 
Did you mean: 

Need mapping help

Former Member
0 Kudos

Hi Gurus,

Below is my requirement.Kindly provide ur inputs.

Source strucutre

Record

Recordset 1:unbounded

srcfield1 0:1

srcfield2 0:1

srcfield3 0:1

srcfield4 0:unbounded

For the unique srcfield1 if there are multiple srcfield4 then i need to create multiple target recordset.Kindly suggest.

eg:

Record

Recordset 1:unbounded

srcfield1 1

srcfield2 abc

srcfield3 xxx

srcfield4 CIL

srcfiled4 RIL

then my target would be

Record

Recordset

srcfield1 1

srcfield2 abc

srcfield3 xxx

srcfield4 CIL

Recordset

srcfield1 1

srcfield2 abc

srcfield3 xxx

srcfiled4 RIL

Thanks in advance.

Edited by: SAPPI_JK on Oct 20, 2010 8:26 PM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

As your Recordset is 1..unbounded it should repeat the Recordset structure multiple times..just map the fields and nodes as per your mapping document and go to Message mapping Test tab and creat a test payload and repeat the payload..and test it should work....

Former Member
0 Kudos

You will need UseOneAsMany standard function for field 1, 2 , 3:

filed1----


>

filed4----


> UseOneAsMany -


> filed1

filed4->SplitByVelue[eachValue]----


>

then, map field 4:

filed4->SplitByVelue[eachValue]----


>field4

you should not forget map to recordset

filed4 -


> recordset

Regards

Liang

Former Member
0 Kudos

Hi,

You can use Node function - useOneAsMany for this purpose. Set the contexts as required. Check link below for more details on this function

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/ef/df564b6aa24fc9ab0d685460747de5/frameset.htm

rgds