Solved: Using HTML tag on xml file from txmlmap - Page 5 - Qlik Community

Anonymous · ‎2018-02-14

Hello, I have a XML file with many rows, and in my tXmlMap, I need one rows who contains html

In this rows, I use the html tag in my tXmlMap, but he stop read at the first line and talend send me error

ORA-01400: Cannot insert NULL into ("DB"."table"."column")

But, other xml file with many html rows , its working for exemple, after my <p> Hello, </p> I press enter to make a new line, its working

Edit: I tried to use this

StringHandling.EREPLACE(row2.html,"</p>","</p><br>")

but nothing

Anonymous · ‎2018-02-16

So now its work

But ( yea again but but but.....) He show me only 1 file , and not all file in directory :s

EDIT: And on my tXMLMap how can I get the data ? because I have only "Content" row on input, and I need to have all xml file structure

Anonymous · ‎2018-02-16

You have connected the tFileList using an OnComponentOK. You need to connect it to the next component using the iterate link. Like before.

The tXMLMap is a new requirement. I do not know what you mean. You were after the <html> data. You have that now. If you want all of the other data, you will need to get it using the tExtractXMLField in a similar way to the html data.

Anonymous · ‎2018-02-16

Its ok !

I will do other tExtractXMLFiedl for other data, thx for your help and your time !

Using HTML tag on xml file from txmlmap

Talend Data Integration