How to Use Advanced XPath Settings

Goal 

An XML file with the following structure needs to be imported and later analyzed in Datameer.

<?xml version='1.0' encoding='Cp1252' ?>
<CONTENT>
<RECORD>
<COLUMN NAME="USERID">
<![CDATA[12345]]>
</COLUMN>
<COLUMN NAME="USERNAME">
<![CDATA[Datameer]]>
</COLUMN>
<COLUMN NAME="USERADDRESS">
<![CDATA[street1:Grosse Ulrichstrasse 7-9,city:Halle (Saale),zip:06110,state:SA,country:DE,type:WORK]]>
</COLUMN>
<COLUMN NAME="CREATIONDATE">
<![CDATA[1253664000000]]>
</COLUMN>
<COLUMN NAME="TITLE">
<![CDATA[Title]]>
</COLUMN>
<COLUMN NAME="CONTENT">
<![CDATA[<body><p>Content in HTML</p></body>]]>
</COLUMN>
</RECORD>
</CONTENT> 

Following the knowledge base article How to Parse XML File Format the question came up, what might be the most efficient setup for importing and later processing. 

Learn

During the XML Import Job setup, provide the value RECORD for the  XML Record Tag Name 

To have each sub-record in a separate column use as XPath

//COLUMN[@NAME='USERID']/text()
//COLUMN[@NAME='USERNAME']/text()
//COLUMN[@NAME='USERADDRESS']/text()
//COLUMN[@NAME='CREATIONDATE']/text()
//COLUMN[@NAME='TITLE']/text()
//COLUMN[@NAME='CONTENT']/text()

Further Information

Check out the documentation on Importing XML Files and Using XPathXML Path Language (XPath) and character data (CDATA).