Skip to Content
1
Jun 01, 2017 at 12:48 PM

Merge two Rowset of XML into one

88 Views Last edit Jun 01, 2017 at 01:00 PM 4 rev

I am working with two XMLs, one generated from MDO Output and another one from File Filter Custom Action output(XML).

Now, I wish to merge both of them without the use of Repeater.

First XML :

<?xml version="1.0" encoding="UTF-8"?>
<Rowsets>
    <Rowset>
        <Row>
            <FileName></FileName>
            <ID></ID>
        </Row>
        <Row>
            <FileName></FileName>
            <ID></ID>
        </Row>
    </Rowset>
</Rowsets>

Second XML :

<?xml version="1.0" encoding="UTF-8"?>
<Rowsets>
    <Rowset>
        <Row>
            <PageName></PageName>
            <Equip_ID></Equip_ID>
        </Row>
        <Row>
            <PageName></PageName>
            <Equip_ID></Equip_ID>
        </Row>
    </Rowset>
</Rowsets>

Output XML should be :

<?xml version="1.0" encoding="UTF-8"?>
<Rowsets>
    <Rowset>
        <Row>
            <FileName></FileName>
            <ID></ID>
        </Row>
        <Row>
            <FileName></FileName>
            <ID></ID>
        </Row>
        <Row>
            <PageName></PageName>
            <Equip_ID></Equip_ID>
        </Row>
        <Row>
            <PageName></PageName>
            <Equip_ID></Equip_ID>
        </Row>
    </Rowset>
</Rowsets>