topic Re: tHMap move namespace from elements to root structure in XML in Talend Studio

tHMap move namespace from elements to root structure in XML

rlooijmans — Thu, 16 May 2024 16:11:14 GMT

Hi all,

How can I move a namespace for an element to the root structure of the XML? Now the xmlns:dt namespace is shown on each and every dt:dt element.

This is what I have:

This is what I want:

Namespace setup:

XML properties

Attribute name:

I couldn't find anything specific in the docs for this. I am sure there must be a straightforward way, but I can't wrap my head around this.

Hopefully someone has an insight on how to achieve this, or has managed to get it working before. Every input is greatly appreciated.

Thanks,
Reno

Re: tHMap move namespace from elements to root structure in XML

Venky2 — Thu, 16 May 2024 17:43:23 GMT

I am just curious to know few more details. I never seen Qlik using the XML file
can you explain a little bit more about the project or the process that you are doing and where does the Qlik sense fall in?
thanks!

Re: tHMap move namespace from elements to root structure in XML

rlooijmans — Fri, 17 May 2024 06:27:58 GMT

Perhaps I was not entirely clear. This XML structure is generated by Talend using tHMap. It's just the namespace being put at each and every element because of an attribute. Instead of repeating, I want it to be put in the root.

Basically this job generates an XML structure with product data from an sql output.

Thanks.

Re: tHMap move namespace from elements to root structure in XML

rlooijmans — Tue, 21 May 2024 07:10:35 GMT

Nobody has any idea? I kinda assumed that something so basic should be easily possible.. 😞

Re: tHMap move namespace from elements to root structure in XML

emariani — Thu, 23 May 2024 15:31:34 GMT

The problem comes from the type Document defined in the schema of the connection row6 (see screenshot schema_with_document). This forces the tHMap component to produce a Document object (which is a dom4j implementation of an XML Document Object Model). The result you get is simply the result of the print of this document.
If you change the type from Document to Object, then the tHMap component will produce an XML string with the namespaces defined at the root level as expected (see screenshot schema_with_Object).