convert XML using XSLT mapping

[Former Member]

Hi,

I have an XML in the following format and would want to cnvert it in the target format shown below. Kindly let me know the XSLT mapping to conert from hierarchy to flat structure.

<u><b>Source XML:</b></u>

<group Level1="Mac Tools Item Classifications">

<group Level2="6-Other Merchandise">

<group Level3="61-Racing">

<group Level4="011-Collectibles">

<group Level5="001-NASCAR"/>

<group Level5="002-NHRA"/>

<group Level5="003-Other"/>

</group>

<group Level4="012-Apparel">

<group Level5="001-Jackets"/>

<group Level5="002-Shirts"/>

<group Level5="003-Other">

<group PartNumber="SHOE823-060"/>

<group PartNumber="SHOE823-070"/>

<group PartNumber="SHOE823-080"/>

<group PartNumber="SHOE823-085"/>

<group PartNumber="SHOE823-090"/>

.......

</group>

</group>

</group>

</group>

</group>

<u><b>Target XML:</b></u>

<Group>

<part>

<Level1/>

<Level2/>

<Level3/>

<Level4/>

<PartNumber/>

</part>

<part>

<Level1/>

<Level2/>

<Level3/>

<Level4/>

<PartNumber/>

</part>

</Group>

I am not clear how to capture level1, level 2, etc. till the end node.

Regards,

Swaroopa

[former_member189387]

HI,

This is a sample

<b>

<xsl:variable name="var0_floatToString" select="user0:floatToString(/body/getQuote/inputGetQuote/@customerIDFloatAttr)"/>

<xsl:if test="@customerIDFloatAttr">

<xsl:attribute name="customerIDFloatAttr">

<xsl:value-of select="@customerIDFloatAttr"/>

</xsl:attribute>

</xsl:if>

<xsl:attribute name="customerIDAttr">

<xsl:value-of select="$var0_floatToString"/>

</xsl:attribute></b>

using <xsl:attribute name here name ="leval1" like that u can use in XSLT Mapping .

Hope it helps

Regards.,

V.Rangrajan

[Former Member]

Hi Rangrajan,

Can you tell me how to traverse to the parent node in XSLT program?

If I find the node "Product" and then traverse back to its parents, then the problem would be solved.

Regards,

Swaroopa

[former_member189387]

Hi,

Have a look at this

http://help.sap.com/saphelp_nw04/helpdata/en/55/7ef3003fc411d6b1f700508b5d5211/content.htm

• Ohh , i misunderstood your question .This link won't help

Regards.,

V.Rangarajan

Message was edited by:

ranga rajan