File content conversion for complex structure

[former_member420422]

Hello,

I have a problem with the FCC for an XML structure with both node and sub node are occurring multiple times.

PI receives an XML and has to write as a flat file to MQ. The file structure is as follows.

<XML tags>

   <HDR>

      <ABC>123</ABC>

      <DEF>456</DEF>

      <LINE>

         <UVW>9876</UVW>

         <XYZ>aaaa</XYZ>

      </LINE>

      <LINE>

        <UVW>5432</UVW>

        <XYZ>bbbb</XYZ>

      </LINE>

   </HDR>

   <HDR>

      <ABC>111</ABC>

      <DEF>222</DEF>

      <LINE>

        <UVW>9999</UVW>

        <XYZ>zzzz</XYZ>

      </LINE>

      <LINE>

        <UVW>8888</UVW>

        <XYZ>yyyy</XYZ>

      </LINE>

      <LINE>

        <UVW>7777</UVW>

        <XYZ>xxxx</XYZ>

      </LINE>

   </HDR>

In the above structure, the HDR will occur multiple times, and the LINE node in each HDR can again occur multiple times.

The output which is a fixed length flat file, should look like

123456

9876aaaa

5432bbbb

111222

9999zzzz

8888yyyy

7777xxxx

Is there any way we can achieve this using content conversion? If not what are the other options?

I would like to avoid Java mapping and any adapter modules. Is XSLT the only choice in that case?

Please help.

Thanks

Justin

[nabendu_sen · Accepted solution]

Hi Justin,

Have the checked the below document?

http://scn.sap.com/people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-...

Regards,

Nabendu.

[former_member420422 · Accepted solution]

Thanks for the blog. I was able to achieve the same with this simple mapping.

Regards

Justin