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,