T
troy
I am attempting to manipulate XML with Excel and am having a problem. The
XML contains a complex element (an element with subelements). When the
import executes, Excel treats the element as a single list, not a series of
lists. And when I try to export it back out I receive the following
messages: Map is not exportable because it contains the following:
Denormalized data; A mapped element's relationship with other elements cannot
be preserved.
The XML file has an underlying XSD defining the complex element.
Sample XML with complex elements:
<Parents>
<Parent>
<Name></Name>
<DOB></DOB>
<Children>
<Child>
<Name></Name>
<DOB></DOB>
</Child>
</Children>
</Parent>
</Parents>
Can someone point me to some doco on how to handle complex xml elements?
XML contains a complex element (an element with subelements). When the
import executes, Excel treats the element as a single list, not a series of
lists. And when I try to export it back out I receive the following
messages: Map is not exportable because it contains the following:
Denormalized data; A mapped element's relationship with other elements cannot
be preserved.
The XML file has an underlying XSD defining the complex element.
Sample XML with complex elements:
<Parents>
<Parent>
<Name></Name>
<DOB></DOB>
<Children>
<Child>
<Name></Name>
<DOB></DOB>
</Child>
</Children>
</Parent>
</Parents>
Can someone point me to some doco on how to handle complex xml elements?