Xml Data - Reading Namespaced File (1 reply)
Zev, the Xml file has a namespace. This needs to be declared and then referenced throughout the reader setup.
Put the namespace with prefix into the namespace field. In this document there is a default namespace. Default namespaces can be problematic, but these issues can be eradicated with a prefix in the declaration. The prefix is essentially a shortcut to the namespace (urn:schemas-microsoft-com:xml-analysis:rowset).
In our example we used a namespace prefix of 'ns', but you can use character string without spaces.
Each XPath must have each node prefixed with the namespace prefix followed by colon followed the node. These are shown in the entry point, record & field XPaths.
How do I read the following file? Having issues reading the file.