Mapping from Multiple Rows to single Row

[Former Member]

Hi,

SOURCE:

<?xml version="1.0" encoding="UTF-8"?>

<SHIP_INFO_HDR>

<SHNUMBER/>

</SHIP_INFO_HDR>

<item> -

---

can be multiple

<DOC_NUMBER/>

<COM_NUMBER/>

</item>

TARGET:

<TARGET>

<SHITEM_ALL>

<DOC_NUMBER_1/>

<DOC_NUMBER_2/>

<DOC_NUMBER_3/>

<DOC_NUMBER_4/>

<DOC_NUMBER_5/>

<DOC_NUMBER_6/>

</SHITEM_ALL>

</TARGET>

My requirement is to map the 1st item with the corresponding fileds in Target and similarly for 2nd item.

I also have to map the rest to zero.

Please suggest.

regards,

Piyush

Edited by: Piyush Mathur SAP on Jan 19, 2011 8:21 AM

[stefan_grube · Accepted solution]

> I also have to map the rest to zero.

What does that mean?

[Former Member · Accepted solution]

Hi Stefan,

This means that the target shuld have 6 DOC_NUM always.

If the source has lets say 3 rows then the target will have the 1st 3 docnums mapped to source and rest 3 as zero.

regards,

Piyush

[stefan_grube · Accepted solution]

> If the source has lets say 3 rows then the target will have the 1st 3 docnums mapped to source and rest 3 as zero.

Add "mapwithdefault" as last step to the sequence.

[Former Member · Accepted solution]

Thanks a lot Stefan....

Appreciate your prompt responses

[former_member200962]

your target in this thread and earlier one seems to be different!

source --> index(1,1) -->  greater --> Ifwithoutelse (Constant(0) --> Then)--> Target3/4/5/6
constant(2) ------->

use above logic for 3rd node onwards.

[Former Member]

Hi Abhishek,

The If without else works absoultely fine but the main problem is the default zero values that have to be passed.

To incorporate the default zeros, I used an If WITH else but it does not give the expected output