Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!