Skip to Content
0
Former Member
Apr 21, 2008 at 02:06 PM

Mapping issue

9 Views

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