Parse it first....getting the xml into a single large varchar column, along with everything else....then go to an XMLInput Stage and do the XML work...."carry" the other columns on both the input link and the output link, with NOTHING in their Description property....the stage supports the concept of "passthru".......they'll just go thru unchanged.
Ernie
Flattening a file which has XML as well as sequential data
Moderators: chulett, rschirm, roy
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>