Hi,
This is my source xml
<Forecast>
    <Product>
        <Id>1</Id>
        <Schedule>
            <ScheduleDetail>
                <StartDate>1</StartDate>
                <EndDate>1</EndDate>
                <Quantity>1</Quantity>
            </ScheduleDetail>
            <ScheduleDetail>
                <StartDate>2</StartDate>
                <EndDate>2</EndDate>
                <Quantity>2</Quantity>
            </ScheduleDetail>
        </Schedule>
    </Product>
    <Product>
        <Id>2</Id>
        <Schedule>
            <ScheduleDetail>
                <StartDate>3</StartDate>
                <EndDate>3</EndDate>
                <Quantity>3</Quantity>
            </ScheduleDetail>
            <ScheduleDetail>
                <StartDate>4</StartDate>
                <EndDate>4</EndDate>
                <Quantity>4</Quantity>
            </ScheduleDetail>
        </Schedule>
    </Product>


And this is the target xml
<Items>
    <Data>
        <Product>1</Product>
        <Startdate>1</StartDate>
        </EndDate>1</EndDate>
        <Quantity>1</Quantity>
    <Data>
    <Data>
        <Product>1</Product>
        <Startdate>2</StartDate>
        </EndDate>2</EndDate>
        <Quantity>2</Quantity>
    <Data>
    <Data>
        <Product>2</Product>
        <Startdate3></StartDate>
        </EndDate>3</EndDate>
        <Quantity>3</Quantity>
    <Data>
    <Data>
        <Product>2</Product>
        <Startdate>4</StartDate>
        </EndDate>4</EndDate>
        <Quantity>4</Quantity>
    <Data>
</Items>
Any ideas how I can do this?

Thanks,
Subir

You're producing one Data element for each ScheduleDetail element in the input, so you will want something like

<xsl:template match="ScheduleDetail">
<Data>
  ...
</Data>
</xsl:template>

The StartDate, EndDate, and Quantity elements can be copied over using <xsl:copy-of select="*"/>, and the Product can be added as

<Product><xsl:value-of select="../preceding-sibling::Id"/></Product>



Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference