Skip to Content
0
Jul 16, 2008 at 03:00 PM

Mapping Challenge

12 Views

Hi Experts,

Coud anyone help me to map the below requirement:

Source structure :

B................................(0..unbounded)

-satzart (0..1)

-Index (0..1)

-Fehlercode (0..1)

Target structure :

A.............(0..unbounded)

-satzart (0..1)

-rgnumber (0..1)

-Fehlercode1 (0..1)

-Fehlercode2 (0..1)

-Fehlercode3 (0..1)

Source file:

<B>

<Satzart>G60</Satzart>

<Index>B</Index>

<Fehlercode>12D1 ME9999W</Fehlercode>

<B>

<B>

<Satzart>G60</Satzart>

<Index>B</Index>

<Fehlercode>12J1 ME9999W</Fehlercode>

</B>

<B>

<Satzart>G60</Satzart>

<Index>B</Index>

<Fehlercode>50A1 ME5000W</Fehlercode>

</B>

The above file has to be mapped to the target structure like follows:

<A>

<Satzart>G60</Satzart>

<rgnumber>B</rgnumber>

<Fehlercode1>12D1 ME9999W</Fehlercode1>

<Fehlercode2>12J1 ME9999W</Fehlercode2>

<Fehlercode3>50A1 ME5000W</Fehlercode3>

</A>

the source field Fehlercode under B node has to be mapped to the target fehlercode1,fehlercode2,fehlercode3.

i.e: the first occurrence from source has to be mapped to Fehlercode1

and second occurrence has to be mapped to Fehlercode2

and third occurrence has to be mapped to Fehlercode3

If more than three occurrence the next can be ignoredu2026

Please help me how to achieve this in mapping.

Regards,

RDS

Edited by: Shankar Raju Devadoss on Jul 16, 2008 5:00 PM

Edited by: Shankar Raju Devadoss on Jul 16, 2008 5:01 PM