Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mapping an XML element more than once??
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! |
#2
|
|||
|
|||
I'm sorry, I don't think I've made myself clear... I've mapped my XML schema to XML Source... and I'm trying to map a child element to multiple cells.... in the Microsoft troubleshooting section, they say "Multiple repeating elements are mapped to the same XML list, and the repetition not defined by an ancestor element" - but I don't know how to fix that. Please... anyone?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
character mapping | Excel Discussion (Misc queries) | |||
character mapping | Excel Discussion (Misc queries) | |||
Anyone know where I can get a basic market mapping template? | Excel Discussion (Misc queries) | |||
Mapping feature in Excel | Excel Discussion (Misc queries) | |||
xy scatter graph with a scrolling time element | Charts and Charting in Excel |