Skip to Content
0
May 07, 2020 at 04:34 AM

flatten xml structure

68 Views Last edit May 07, 2020 at 04:36 AM 2 rev

Hi Everyone,

I am trying to flatten an XML structure and convert it into a CSV file. I tried using the message mapping but could not get it. Please let me know how we can achieve this.

Input XML
<User>
    <User>
      <matrixManager>
        <User>
          <userId>MM1</userId>
        </User>
        <User>
          <userId>MM2</userId>
        </User>
      </matrixManager>
      <manager>
        <User>
          <userId>MGR1</userId>
        </User>
      </manager>
      <userId>USR01</userId>
      <username>USRNM01</username>
    </User>
    <User>
      <matrixManager>
        <User>
          <userId>MM3</userId>
        </User>
      </matrixManager>
      <manager>
        <User>
          <userId>MGR2</userId>
        </User>
      </manager>
      <userId>USR02</userId>
      <username>USRNM02</username>
    </User>    
</User>
Output XML or CSV file
<User>
    <User>
      <matrixManager>MM1</matrixManager>
      <matrixManager>MM2</matrixManager>
      <manager>MGR1</manager>
      <userId>USR01</userId>
      <username>USRNM01</username>
    </User>
    <User>
      <matrixManager>MM3</matrixManager>
      <manager>MGR2</manager>
      <userId>USR02</userId>
      <username>USRNM02</username>
    </User>    
</User>

Regards,