splitting XML with multiple root level

Niv0599 · Post by **Niv0599** » Wed Sep 12, 2012 6:16 am

Hello,

Is there a way in data stage to split an XML file with multiple root level?

I have a MQ connector sending replies in XML that has multiple root level tag, as it will fail in parsing, trying to find a way to split it.

Please let me know, if it's possible.

Thanks,
Das

eostic · Post by **eostic** » Thu Sep 13, 2012 4:35 am

...try first concatenating another fake root around it, and then retrieve all the "root" elements as the first repeating node...

Ernie

rameshrr3 · Post by **rameshrr3** » Thu Sep 13, 2012 10:04 am

Hmm Interesting , Can someone use an XML output stage to add the top level root once they grab it from MQ ? Assuming the xml column is tagged as data element XML

eostic · Post by **eostic** » Thu Sep 13, 2012 7:58 pm

why bother? A transform derivation is a WHOLE lot easier.....

'<xml? version="1.0" ?><myRoot>' : myMQoutputLink.message : '</myRoot>'

done.

Ernie