Convert Flat structure to Nested

dani1 · October 29th, 2008, 02:23 AM

Hi! I need do convert a flat structure to nested one.
I know how to do this using the condition, but now I don't have any common "keys" between the items.
I need to save the original order of the items.

[u]Source structure:</u>

<root>
    <Invoice>
        <InvType>0</InvType>
        <InvNum>111</InvNum>
    </Invoice>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>111</DeliveryNum>
        <Amount>100.00</Amount>
    </Delivery>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>333</DeliveryNum>
        <Amount>200.00</Amount>
    </Delivery>
    <Invoice>
        <InvType>0</InvType>
        <DeliveryNum>222</DeliveryNum>
    </Invoice>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>222</DeliveryNum>
        <Amount>300.00</Amount>
    </Delivery>
</root>

[u]Target:</u>

<root>
    <Invoice>
        <InvType>0</InvType>
        <InvNum>111</InvNum>
        <Delivery>
             <DeliveryType>1</DeliveryType>
             <DeliveryNum>111</DeliveryNum>
             <Amount>100.00</Amount>
        </Delivery>
        <Delivery>
             <DeliveryType>1</DeliveryType>
             <DeliveryNum>333</DeliveryNum>
             <Amount>200.00</Amount>
        </Delivery>
    </Invoice>

    <Invoice>
        <InvType>0</InvType>
        <DeliveryNum>222</DeliveryNum>
        <Delivery>
                <DeliveryType>1</DeliveryType>
                <DeliveryNum>222</DeliveryNum>
                <Amount>300.00</Amount>
        </Delivery>
    </Invoice>
</root>

[u]Here is my code:</u>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:template match="/">
        <root>
            <xsl:for-each select="root/Invoice">
                <Invoice>
                    <InvType>
                        <xsl:value-of select="InvType"/>
                    </InvType>
                    <InvNum>
                        <xsl:value-of select="InvNum"/>
                    </InvNum>
********Here I can insert a condition, but I don't have any :(*******
For example: <xsl:for-each select="../Delivery[DeliveryType=../Invoice/InvType]">
************************************************** *****************
                        <Delivery>
                            <DeliveryType>
                                <xsl:value-of select="DeliveryType"/>
                            </DeliveryType>
                            <DeliveryNum>
                                <xsl:value-of select="DeliveryNum"/>
                            </DeliveryNum>
                            <Amount>
                                <xsl:value-of select="Amount"/>
                            </Amount>
                        </Delivery>
                    </xsl:for-each>
                </Invoice>
            </xsl:for-each>
        </root>
    </xsl:template>
</xsl:stylesheet>

How can solve the problem?

rajesh_css · October 29th, 2008, 02:36 AM

Hi,

<Invoice>
        <InvType>0</InvType>
        <InvNum>111</InvNum>
    </Invoice>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>111</DeliveryNum>
        <Amount>100.00</Amount>
    </Delivery>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>333</DeliveryNum>
        <Amount>200.00</Amount>
    </Delivery>
    <Invoice>
        <InvType>0</InvType>
        <DeliveryNum>222</DeliveryNum>
    </Invoice>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>222</DeliveryNum>
        <Amount>300.00</Amount>
    </Delivery>

is this the way u r expecting

<xsl:template match="/">
        <xsl:copy-of select="./node()" />
    </xsl:template>

will give the result as i mentioned.here the invoice tag is ending before the delivery tag.

Raj

dani1 · October 29th, 2008, 02:51 AM

Quote:

quote:Originally posted by rajesh_css
Hi,

<Invoice>
        <InvType>0</InvType>
        <InvNum>111</InvNum>
    </Invoice>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>111</DeliveryNum>
        <Amount>100.00</Amount>
    </Delivery>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>333</DeliveryNum>
        <Amount>200.00</Amount>
    </Delivery>
    <Invoice>
        <InvType>0</InvType>
        <DeliveryNum>222</DeliveryNum>
    </Invoice>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>222</DeliveryNum>
        <Amount>300.00</Amount>
    </Delivery>

is this the way u r expecting

<xsl:template match="/">
        <xsl:copy-of select="./node()" />
    </xsl:template>

will give the result as i mentioned.here the invoice tag is ending before the delivery tag.
Raj

Hi Raj!

This is the source flat structure:

<Invoice>
        <InvType>0</InvType>
        <InvNum>111</InvNum>
    </Invoice>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>111</DeliveryNum>
        <Amount>100.00</Amount>
    </Delivery>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>333</DeliveryNum>
        <Amount>200.00</Amount>
    </Delivery>
    <Invoice>
        <InvType>0</InvType>
        <DeliveryNum>222</DeliveryNum>
    </Invoice>
    <Delivery>
        <DeliveryType>1</DeliveryType>
        <DeliveryNum>222</DeliveryNum>
        <Amount>300.00</Amount>
    </Delivery>

I expecting to the nested structure, like that:

<root>
    <Invoice>
        <InvType>0</InvType>
        <InvNum>111</InvNum>
        <Delivery>
             <DeliveryType>1</DeliveryType>
             <DeliveryNum>111</DeliveryNum>
             <Amount>100.00</Amount>
        </Delivery>
        <Delivery>
             <DeliveryType>1</DeliveryType>
             <DeliveryNum>333</DeliveryNum>
             <Amount>200.00</Amount>
        </Delivery>
    </Invoice>