Hi, specialists! Please help me.

I need to convert nested XML to flat one:

[u]Source file:</u>

<root>
<Header>
    <Hdr>1</Hdr>
        <Order>
            <OrderNum>11</OrderNum>
            <Line>
                <LineNum>222</LineNum>
            </Line>
            <Line>
                <LineNum>333</LineNum>
            </Line>
            <Line>
                <LineNum>444</LineNum>
            </Line>
        </Order>
        <Order>
            <OrderNum>55</OrderNum>
            <Line>
                <LineNum>666</LineNum>
            </Line>
            <Line>
                <LineNum>777</LineNum>
            </Line>
        </Order>
</Header>
</root>

[u]Target:</u>


<root>
    <Header>
        <Hdr>1</Hdr>
    </Header>
    <Order>
        <OrderNum>11</OrderNum>
    </Order>
    <Line>
        <LineNum>222</LineNum>
    </Line>
     <Line>
        <LineNum>333</LineNum>
    </Line>
     <Line>
        <LineNum>444</LineNum>
    </Line>
     <Order>
        <OrderNum>55</OrderNum>
    </Order>
    <Line>
        <LineNum>666</LineNum>
    </Line>
        <Line>
        <LineNum>777</LineNum>
    </Line>
</root>

When I am using "for each" XSLT broking the order of the elements:

<root>
    <Header></Header>
    <Order></Order>
    <Order></Order>
    <Line></Line>
    <Line></Line>
    <Line></Line>
    <Line></Line>
    <Line></Line>
</root>

How can I avoid that?

Try this:

<xsl:template match="/">
        <root>
        <xsl:apply-templates/>
        </root>
    </xsl:template>

    <xsl:template match="Hdr">
        <Header>
        <xsl:copy-of select="."/>
            </Header>
    </xsl:template>

    <xsl:template match="OrderNum">
        <Order>
        <xsl:copy-of select="."/>
        </Order>
    </xsl:template>
    <xsl:template match="Line">
        <xsl:copy-of select="."/>
    </xsl:template>

WOW! That's it!!!
mrame, thank you!

I can't tell you why your code is doing the wrong thing, because you haven't shown your code. (We may be specialists, and we do get a lot of practice, but it's still difficult to debug code when you can't see it.)

Don't use for-each, use template rules. Something like

<xsl:template match="Line">
  <xsl:copy-of select="."/>
</xsl:template>

<xsl:template match="Order">
  <Order>
    <xsl:copy-of select="OrderNum"/>
  </Order>
  <xsl:apply-templates/>
</xsl:template>

<xsl:template match="Header">
  <Header>
    <xsl:copy-of select="Hdr"/>
  </Header>
  <xsl:apply-templates/>
</xsl:template>

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

Now I have another problem. I have more complex structure:

<root>
    <Header>
        <Hdr>1</Hdr>
        <Data1>777</Data1>
        <Data2>888</Data2>
        <Data3>999</Data3>
        <Order>
            <OrderNum>11</OrderNum>
            <OrderData1>555</OrderData1>
            <OrderData2>666</OrderData2>
            <OrderData3>777</OrderData3>

            <Line>
                <LineNum>222</LineNum>
            </Line>
            <Line>
                <LineNum>333</LineNum>
            </Line>
            <Line>
                <LineNum>444</LineNum>
            </Line>
        </Order>
        <Order>
            <OrderNum>55</OrderNum>
            <OrderData1>3232</OrderData1>
            <OrderData2>5656</OrderData2>
            <OrderData3>878</OrderData3>
            <Line>
                <LineNum>666</LineNum>
            </Line>
            <Line>
                <LineNum>777</LineNum>
            </Line>
        </Order>
    </Header>
</root>

How can I transfer all those fields?

Try this:
  <xsl:template match="/">
        <root>
            <xsl:apply-templates/>
        </root>
    </xsl:template>

    <xsl:template match="Header">
        <Header>
            <xsl:copy-of select="Hdr"/>
        </Header>
    </xsl:template>

    <xsl:template match="Order">

        <xsl:copy-of select="OrderNum"/>

    </xsl:template>



        <xsl:template match="OrderNum"/>
    <xsl:template match="Line">
        <xsl:copy-of select="."/>
    </xsl:template>

Rummy

Thanks Rummy. I'll try the code.

2 mhkay
Michael, you're right. I am sorry. Next time I'll attach my code.

OK, here is my code:

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

    <xsl:template match="/">
        <root>
            <xsl:apply-templates/>
        </root>
    </xsl:template>
    <xsl:template match="Line">
        <xsl:copy-of select="."/>
    </xsl:template>

    <xsl:template match="Order">
        <Order>
            <xsl:copy-of select="OrderNum"/>
            <xsl:copy-of select="OrderData1"/>
            <xsl:copy-of select="OrderData2"/>
            <xsl:copy-of select="OrderData3"/>
        </Order>
        <xsl:apply-templates/>
    </xsl:template>

    <xsl:template match="Header">
        <Header>
            <xsl:copy-of select="Hdr"/>
            <xsl:copy-of select="Data1"/>
            <xsl:copy-of select="Data2"/>
            <xsl:copy-of select="Data3"/>
        </Header>
        <xsl:apply-templates/>
    </xsl:template>
</xsl:stylesheet>


It's working pretty good, but there is one problem, after closing the tag(for example <Header> or <Order>) I see all values in one line:



<root>
    <Header>
        <Hdr>1</Hdr>
        <Data1>777</Data1>
        <Data2>888</Data2>
        <Data3>999</Data3>
    </Header>1 777 888 999
    <Order>
        <OrderNum>11</OrderNum>
        <OrderData1>555</OrderData1>
        <OrderData2>666</OrderData2>
        <OrderData3>777</OrderData3>
    </Order>11 555 666 777
    <Line>
        <LineNum>222</LineNum>
    </Line>
    <Line>
        <LineNum>333</LineNum>
    </Line>
    <Line>
        <LineNum>444</LineNum>
    </Line>

    <Order>
        <OrderNum>55</OrderNum>
        <OrderData1>3232</OrderData1>
        <OrderData2>5656</OrderData2>
        <OrderData3>878</OrderData3>
    </Order>55 3232 5656 878
    <Line>
        <LineNum>666</LineNum>
    </Line>
    <Line>
        <LineNum>777</LineNum>
    </Line>
</root>

Get rid of the the xsl:apply-templates in
that way you process any child nodes and there is a built-in template that copies text nodes.
There is also an xsl:apply-templates in
that you need to remove as well.

--
  Martin Honnen
  Microsoft MVP - XML

Please don't think in terms of "closing the tag". You're writing a tree of nodes, not a sequence of start and end tags.

The reason that there's a text node after the <Order> element is that you wrote it when you did

        <Order>
            <xsl:copy-of select="OrderNum"/>
            <xsl:copy-of select="OrderData1"/>
            <xsl:copy-of select="OrderData2"/>
            <xsl:copy-of select="OrderData3"/>
        </Order>
        <xsl:apply-templates/>

If you don't want it, why are you doing the apply-templates?

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