Skip to Content
Feb 24, 2014 at 05:21 PM

Split XML into multiple records


Hi All,

I have to split an XML field from a data type into multiple records on the target side.

For eg: If the source XML string is something like this:





<addr1> </addr1>










Since the above XML string has two records in it (each record includes name and place), I would like to split those two into two separate records in the target structure and send it to ECC.

How can I achieve this in PI mapping. Here in this case I cannot even differentiate between <> </> to split the messages since a single records might have multiple sub nodes in it. It is only believed that when "<name>" repeats again in the XML that would be a start of new record. Based upon that I need to split the records.

Thanks in advance!!