Need Full Iterated Header while parsing nested XML to CSV format.

[rajendraabanawe]

I have got a complex XML which is in nested format and I am looking to convert it to csv format, however I have got some workflows which pulls headers and its corresponding values which is great.

But my requirement is I need to form headers which will iterate over xml on all nodes and will form something like "[Parent]+[Child1]+[Child2]+[Child3]".

So if My [Parent] = "FullForm" , [Child1] = "Ref", [Child2] = "Txn", [Child3] = "Val1", so my Header would be "FullForm_Ref_Txn_Val1", currently I get only "Val"

[OllieClarke]

Can you share some example data and a desired output please. It'll be easier to help you

Ollie

[rajendraabanawe]

Thanks for your response Ollie.

Sure, see below xml format: 

<RcncltnCtgrs>

      <RptgRqrmnt>

             <RptgTp>TWOS</RptgTp>

             <Pairg>UNPR</Pairg>

My expected header is :
RcncltnCtgrs.RptgRqrmnt.RptgTp
RcncltnCtgrs.RptgRqrmnt.Pairg