Hi, I'm trying to map a single XML element to multiple columns in Excel and I'm having a bit of trouble. For example, my mapped schema looks like this:

<?xml version="1.0" encoding="utf-8" ?
<schema xmlns="http://www.w3.org/2001/XMLSchema"
<element name="Root"
<complexType
<sequence
<element name="Distribution" maxOccurs="unbounded"
<complexType
<sequence
<element name="town" type="positiveInteger" /
<element name="species" type="positiveInteger" /
</sequence
</complexType
</element
</sequence
</complexType
</element
</schema



and I want to map species to a bunch of columns... however, I get the message: This element is aleady mapped, an element cannot be mapped more than once.

I read somewhere that you have to change the ancestor element... but I'm not sure what to do. Can anyone help?

Thanks!