0

Converting data XML sequential rows of data to tables in another XML

Hi

I have following xml which I want to convert them into different tables when it find a row with header and all following rows as table data until it finds another row with header. the xml looks like below.

<?xml version="1.0" encoding="UTF-8"?>
<root>
    <table>
        <row>
            <header>
                <paragraph>Rank</paragraph>
            </header>
            <header>
                <paragraph>Name</paragraph>
            </header>
        </row>
        <row>
            <cell>
                <paragraph>1</paragraph>
            </cell>
            <cell>
                <paragraph>knko</paragraph>
            </cell>
        </row>

        <row>
            <header>
                <paragraph>2</paragraph>
            </header>
            <header>
                <paragraph>sample</paragraph>
            </header>
        </row>
        <row>
            <header>
                <paragraph>3</paragraph>
            </header>
            <header>
                <paragraph>third</paragraph>
            </header>
        </row>

        <row>
            <header>
                <paragraph>Leading</paragraph>
            </header>
            <header>
                <paragraph>Flight</paragraph>
            </header>
        </row>
        <row>
            <header>
                <paragraph>300</paragraph>
            </header>
            <header>
                <paragraph>junkname</paragraph>
            </header>
        </row>
        <row>
            <header>
                <paragraph>400</paragraph>
            </header>
            <header>
                <paragraph>Currency</paragraph>
            </header>
        </row>

    </table>

</root>

I wanted to convert this into 2 tables like below

<root>
    <table>
        <tr>
            <th>Rank</th>
            <th>Name</th>
        </tr>
        <tr xmlns="">
            <td>1</td>
            <td>knko</td>
        </tr>
        <tr xmlns="">
            <td>2</td>
            <td>sample</td>
        </tr>
        <tr xmlns="">
            <td>3</td>
            <td>third</td>
        </tr>
    </table>
    <table>
        <tr>
            <th>Leading</th>
            <th>Flight</th>
        </tr>
        <tr xmlns="">
            <td>300</td>
            <td>junkname</td>

        </tr>
        <tr xmlns="">
            <td>400</td>
            <td>Currency</td>
        </tr>
    </table>
</root>

I am a new to XSLT , thanks in advance for your help.

Regards
Sri

2
Contributors
1
Reply
3
Views
4 Years
Discussion Span
Last Post by FakeTales
0

you can do this by using PHP to get the xml data and place it into a JSON string then you can use javascript/jQuery to create a table

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.