Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to convert String to xml Document

Hi,
Trying to parse database varchar column as XML document, here what I did
1. in tMap, convert string column to Document by calling ParseUtils.parseTo_Document(xmlString)
2. in tXMLMap, use metadata xml defintion and map the xml elements/attributes to output columns.
The job compiles OK. but the columns all come out null. I try the same xml as file, the tFileInputXML parse the column correctly.
Am I missing any step?
I am using TOS 4.2.1
Labels (3)
3 Replies
Anonymous
Not applicable
Author

I switched to tExtractXMLField and it worked. Still wondering why above approach failed.
Anonymous
Not applicable
Author

Hi,
You may have encountered a bug that will be fixed in 4.2.3.
http://www.talendforge.org/bugs/view.php?id=22500
-Carl
Anonymous
Not applicable
Author

From another post, I found tConvertType which did exactly what I was looking for here!