PI Mapping Idoc with multiple headers to flat file

[Former Member]

Hello,

I have a mapping with an outbound Idoc with multiple headers segement like that :

<header>

     <Theme>THEME1</Theme>

     <Designation>Designation1</Designation>

     <Date>Date1</Date>

     <Items>

          <Theme>THEME1</Theme>

          <Matnr>Matnr1</Matnr>

     <Items>

          <Theme>THEME1</Theme>

          <Matnr>Matnr2</Matnr>

<header>

     <Theme>THEME2</Theme>

     <Designation>Designation2</Designation>

     <Date>Date2</Date>

     <Items>

          <Theme>THEME2</Theme>

          <Matnr>Matnr1</Matnr>

     <Items>

          <Theme>THEME2</Theme>

          <Matnr>Matnr2</Matnr>

And I want put it into a flat file with this structure :

<DATA>

     <Matnr>Matnr1</Matnr>

     <Theme>THEME1</Theme>

     <Designation>Designation1</Designation>

     <Date>Date1</Date>

</DATA>

<DATA>

     <Matnr>Matnr2</Matnr>

     <Theme>THEME1</Theme>

     <Designation>Designation1</Designation>

     <Date>Date1</Date>

</DATA>

<DATA>

     <Matnr>Matnr1</Matnr>

     <Theme>THEME2</Theme>

     <Designation>Designation2</Designation>

     <Date>Date2</Date>

</DATA>

<DATA>

     <Matnr>Matnr2</Matnr>

     <Theme>THEME2</Theme>

     <Designation>Designation2</Designation>

     <Date>Date2</Date>

</DATA>

I couldn't use function UseOneAsMany because I have multiple headers segment on my Idoc.

But I have same field <Theme> in header segment and item segment. I could use this field as a key but i don't know how...

How could I do ?

Thanks

[former_member184720 · Accepted solution]

I think you can use "use one as many".

Create DATA segment for each <ITEMS>

when it comes Designation and date mapping, use "Use one as many" -> split by value(each value)

[Former Member · Accepted solution]

Thanks for your answer.

I have already try it but in my target fields I have only the items 1 and 2 corresponding to header 1, I haven't the 2 others items corresponding to header 2.

Here is my result :

<DATA>

     <Matnr>Matnr1</Matnr>

     <Theme>THEME1</Theme>

     <Designation>Designation1</Designation>

     <Date>Date1</Date>

</DATA>

<DATA>

     <Matnr>Matnr2</Matnr>

     <Theme>THEME1</Theme>

     <Designation>Designation1</Designation>

     <Date>Date1</Date>

</DATA>

[former_member184720 · Accepted solution]

Your Data node mapping should be

ITEMS -> Remove Context -> Data.

I assume you are missing the remove context here..

[Former Member · Accepted solution]

Yes you're right.

I was used Remove Context on fields, not on Node.

When I place Remove Context on Node, it's OK.

Thank you very much for your help.