Mapping issue

[Former Member]

Help with this mapping

Source structure :

<recordset> -

---

> (0...unbounded)

<CustomerNumber></CustomerNumber>

<CustomerDept></CustomerDept>

<ORG></ORG>

<WTG></WTG>

<SPT> </SPT>

<ZFT></ZFT>

<STO></STO>

<SOTO></SOTO>

</recordset>

Target structure :

<recordset> -

---

> (0...unbounded)

<CustomerNumber></CustomerNumber>

<CustomerDept></CustomerDept>

<Level2> -

---

> (0...unbounded)

<ORG></ORG>

<WTG></WTG>

<SPT> </SPT>

<Level3> -

---

> (0...unbounded)

<ZFT></ZFT>

<STO></STO>

<SOTO></SOTO>

</Level3>

</Level2>

</recordset>

Input file :

Customer number - 12345

Customer dept - 300

ORG - U10

WTG - 10

SPT - 10

ZFT - 3600

STO- 000117

SOTO - 00277

The problem is to provide multiple ZFT + STO and SOTO for every unique ORGWTGSPT and CustomerNumber

Appreciate your help

Thankyou

[Former Member]

Hi,

-you need one udf which sort out the unique value for your combination of ORGWTGSPT and CustomerNumber.

-In udf use result.addSuppress() for non unique combination and map this udf's output to level2 node.

-Map level3 node one to one with recordset node of source structure.

try this you will get appropriate output.

Regards,

Rohit

[Former Member]

Hi,

[Former Member]

Can you provide the actual file content in your query to be able to understand the problem better?

Indranil

[Former Member]

hi ,

you will use "use one as many with split by value " function in mapping...

check the link below...

[http://help.sap.com/saphelp_nw04/helpdata/en/ef/df564b6aa24fc9ab0d685460747de5/content.htm]

*Award points if it useful*

Regards,

Prakasu