XML Nodes Issues

Hi, i’m trying to generate an XML file, with a known structurem based on the data of an Excel table. I was able to convert the Excel data to XML using the Column to XML and XML Column Combiner nodes. iI was also able to create the XML file using the XML Writer Node.

Currently i have issues in these Nodes.

  1. Column to XML: One of the columns of the XML has a Prefix defining it, with a xmlns and an URL. Whenever i try to create the XML Column with the prefix on it i get this error:

“Execute failed: org.xml.sax.SAXParseException; lineNumber: 2; columnNumber: 18; The preffix “DIMisc” of the element “DIMisc:DocType” is not declared”

Are there any suggestions on how to create this column ?

PS: I need to create this column to then combine it under the column that has the XMLNS and URL defined.

  1. XML Column Combiner: The XML has a Default Naming Space (aka xmlns=“URL”). If i try and configure it as a “Custom Attribute” in the “XML Element Properties” the output created replicaticates the xmlns attribute to the combined columns but with no URL (aka )

PS: I thought about adding a prefix to all the combined columns, but then i get back to the other error i mentioned in this post.