xslt code help needed

[Former Member]

Dear SAP experts,

Would you be able to help me in configuring the right xslt code to accomodate the looping logic?

Source Document:

School (occur only once)

- Name (can occur multiple times)

- Nickname (occur only once)

- Desired name (occur only once)

Target Document:

School

- Name

- Nickname (the value for this should be obtained from 'Desired name field')

- Desired name

I have this code, but seems not working in looping logic. (to accomodate the multiple Names):

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="xml" version="1.0" media-type="xml" encoding="UTF-8" indent="yes"/>

<xsl:template match="@*|node()">

<xsl:copy>

<xsl:apply-templates select="@*|node()"/>

</xsl:copy>

</xsl:template>

<xsl:template match="Order/OrderDetail/ListOfItemDetail/ItemDetail/BaseItemDetail/ItemIdentifiers/PartNumbers/BuyerPartNumber">

<BuyerPartNumber>

<PartNum>

<PartID>

<xsl:value-of select ="/Order/OrderDetail/ListOfItemDetail/ItemDetail/BaseItemDetail/ItemIdentifiers/PartNumbers/ManufacturerPartNumber/PartID"/>

</PartID>

</PartNum>

</BuyerPartNumber>

</xsl:template>

</xsl:stylesheet>

What happened is that the value was taken ONLY on the 1st line item. (1st Name occurence)

The succeeding Name field just copied the value of Nicknames from the 1st Name field.

Kindly advise how to handle the context (loop logic) in the xslt code.

Thanks!

[Former Member]

Apologies, but, it seems i did not indicate the complete message structure for the document I am testing.

Order (root)

OrderHeader (1st parent segment)

OrderNumber (child fields - 1st)

Order.. (child fields - 2nd)

Order...(child fields - 2nd)

OrderDetail (1st parent segment)

<fields under this segment were already mentioned from previous threads>

OrderSummary (1st parent segment)

NumOfLines (child fields - 1st)

TotalAmount (child fields - 1st)

Under Order, there are also OrderHeader and OrderSummary parent segment, other than OrderDetail, in which we focus our code.

I've tried your code, but, the segments OrderHeader and OrderSummary and child fields under it were not appearing on my output.

But it seems, I've already generated the correct code.

Here it is,

<?xml version="1.0" encoding="utf-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="xml" version="1.0" media-type="xml" encoding="UTF-8" indent="yes"/>

<xsl:template match="@*|node()">

<xsl:copy>

<xsl:apply-templates select="@*|node()"/>

</xsl:copy>

<xsl:template match="/Order/OrderDetail/ListOfItemDetail/ItemDetail/BaseItemDetail/ItemIdentifiers/PartNumbers/BuyerPartNumber">

<xsl:for-each select=".">

<BuyerPartNumber>

<PartNum>

<PartID>

<xsl:value-of select="../ManufacturerPartNumber/PartID"/>

</PartID>

</PartNum>

</BuyerPartNumber>

</xsl:for-each>

</xsl:template>

</xsl:stylesheet>

I believe, the code you've suggested last time will accomodate only OrderDetail parent segment. Is this correct?

Thanks!