I have the following schema:
<import>
<node type="document" action="action">
<location>Spain:Development</location>
<title>Abono de factura</title>
<file>D:\OPENTEXT\12343fewf.pdf</file>
<category name="Content Server Categories:Non SAP Categories:Common:Migracion_Documentum">
<attribute name="Autor">ppieroni</attribute>
<attribute name="ID Documentum">E-0008749312</attribute>
</category>
</node>
<node type="document" action="action">
<location>Spain:Systems</location>
<title>Factura pendiente</title>
<file>D:\OPENTEXT\89443gs.xlsx</file>
<category name="Content Server Categories:Non SAP Categories:Common:Migracion_Documentum">
<attribute name="Autor">jcarballeira</attribute>
<attribute name="ID Documentum">I-0001245366</attribute>
</category>
</node>
</import>
When I import an XML file following this schema, Excel lays out the data as follows:
https://i.ibb.co/8xj55jM/XML-mapping.jpg
It seems that Excel cannot map more than one attribute having repeated elements with different name tags, since I have to choose between mapping "Autor" or "ID Documentum".
I would need to be able to map more than one repeated row with different attributes and values in it.
How could I achieve this?
Regards
You could use a XML parser.
Required reference via vbe > tools> references to Micorsoft XML library (v.6 for me)