parsing xml( in a table column)

reddy12 · Post by **reddy12** » Tue Aug 12, 2008 8:35 am

experts,

i have a question.
i have a table in which a column has xml tag/message.

is it possible to parse the xml message/tag to columns???

appreciate any help.

Regards.

throbinson · Post by **throbinson** » Tue Aug 12, 2008 9:23 am

Yes. There is nothing special about the source of the XML into the XMLInput Stage. Read the column that contains the XML into the XMLInput and parse as normal.

reddy12 · Post by **reddy12** » Tue Aug 12, 2008 11:02 am

throbinson
thanks for the reply.
Is it just that get the column in which i have the xml tag and parse it in xml input stage???

thanks

throbinson · Post by **throbinson** » Tue Aug 12, 2008 1:27 pm

You can do both. The XMLInput Stage can be a pass through for non-XML fields. Identify the XML field as a being of Data element XML.
Why not try it? Your box will not explode.

chulett · Post by **chulett** » Tue Aug 12, 2008 4:29 pm

Are you su<KA-BLAM!> Dang.