I am trying to map two XSD and generate the XSL file which will transform from one xml to another.
Source XML
+<root>+
+<Hello>Well</Hello>+
+<World>Thats</World>+
+</root>+
Destination XML
+<root>+
+<property name="Consumer" value="Well"/>+
+<property name="Consumer" value="Thats"/>+
+</root>+
Since the the destination XSD has same element twice, in its XSD it appears only once. So there only one node in the XSL Map tree in the right side of the JDeveloper (version 11.1.1.5.0)
I can only drag lines from either <hello> or <world> from the 1st XSD to the <property> element of the second XSD.
When I changed the XML map's xsl source to match my requirement as follows
+<xsl:template match="/">+
+<root>+
+<ns0:property>+
+<xsl:attribute name="name">+
+<xsl:text disable-output-escaping="no">Consumer</xsl:text>+
+</xsl:attribute>+
+<xsl:attribute name="value">+
+<xsl:value-of select="/root/Hello"/>+
+</xsl:attribute>+
+</ns0:property>+
+<ns0:property>+
+<xsl:attribute name="name">+
+<xsl:text disable-output-escaping="no">Consumer</xsl:text>+
+</xsl:attribute>+
+<xsl:attribute name="value">+
+<xsl:value-of select="/root/World"/>+
+</xsl:attribute>+
+</ns0:property>+
+</root>+
+</xsl:template>+
+</xsl:stylesheet>+
It works when I test the xsl but I can not go back to the design mode, it is showing the following error
Error : XSL map generation failed
Error: This node is already mapped, repeating nodes not supported :
I am not able to map (drag lines) any more due this error. Please suggest how to create repeating nodes in the destination XSD
Edited by: neilghoshidc on May 21, 2012 6:53 PM