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
splitting XML with multiple root level
Moderators: chulett, rschirm, roy
splitting XML with multiple root level
Datastage is the best thing that happened to ETL
...try first concatenating another fake root around it, and then retrieve all the "root" elements as the first repeating node...
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
why bother? A transform derivation is a WHOLE lot easier.....
'<xml? version="1.0" ?><myRoot>' : myMQoutputLink.message : '</myRoot>'
done.
Ernie
'<xml? version="1.0" ?><myRoot>' : myMQoutputLink.message : '</myRoot>'
done.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>