Unable to extract data from XML column using tExtractXMLfield

One Star

Unable to extract data from XML column using tExtractXMLfield

I have a table which has BREVNT as follow
NAME TYPE LENGTH
ID Integer 100
DEFN_NAME String 100
DEFN_DETAIL XML

I am trying to use tExtractXML field component to get data out of DEFN_DETAIL into a CSV file.
I get the NamespaceTool error.
when i retrieve the table from Database onto designer i get the column as string .
And using tXMLextract component i want to read the XML column and spit it out as CSV file.
My question is
Am i doing the correct setting in the tXMLExtract component.
Do i need to specify the XSD of this XML beforehand ? I thought TXMLExtract is to read XML Column in Database if so i dont think i should define XSD anywhere.
I have been struggling on this for last 2 days.

Would greatly appreciate if someone can look at screen shot and help me on this
Highlighted
Community Manager

Re: Unable to extract data from XML column using tExtractXMLfield

Hi
I think you are using the right component tExtractXMLfield to extract values from a string data with XML format, you might have wrong settings on tExtractXMLfield component if it does not work. Please provider us more details about your job settings, some screenshots of the component will be helpful for us to address the problem quickly, or give us an example of your string data and what values do you want to extract from it?
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now