Transpose ROW Data in Column

[mashfaq]

Dear All,

             I have data in XML as given below & I want data as given below:

//------------------------------------------------

<?xml version="1.0" encoding="UTF-8"?><Rowsets DateCreated="2015-09-22T14:58:11" EndDate="2014-11-26T12:17:44" StartDate="2014-11-26T12:17:44" Version="14.0 SP5 Patch 15 (Nov 20, 2014)">

    <Rowset>

        <Columns>

            <Column Description="Sale" MaxRange="1" MinRange="0" Name="Sale" SQLDataType="1" SourceColumn="Sale"/>

            <Column Description="Date" MaxRange="1" MinRange="0" Name="Date" SQLDataType="93" SourceColumn="Date"/>

            <Column Description="Material" MaxRange="1" MinRange="0" Name="Material" SQLDataType="1" SourceColumn="Material"/>

            <Column Description="Quantity" MaxRange="1" MinRange="0" Name="Quantity" SQLDataType="8" SourceColumn="Quantity"/>

        </Columns>

        <Row>

            <Sale>OPC</Sale>

            <Date>2013-01-01T00:00:00</Date>

            <Material>1000002</Material>

            <Quantity>395.52</Quantity>

        </Row>

        <Row>

            <Sale>SRC</Sale>

            <Date>2013-01-02T00:00:00</Date>

            <Material>1000004</Material>

            <Quantity>88.14</Quantity>

        </Row>

        <Row>

            <Sale>OPC</Sale>

            <Date>2013-01-03T00:00:00</Date>

            <Material>1000002</Material>

            <Quantity>483.42</Quantity>

        </Row>

//------------------------------------------------

My desire format is given Below:

                Date
                   01-01-2013       02-01-2013         03-01-2013

OPC      395                    0                         483.42

SRC     0                         88.14                    0

Kindly help me in this issue.

Thanks

Muhammad Ashfaq

[mashfaq]

Dear Christian,

      I use XSL but it did for only two column & give me result as below:

<?xml version="1.0" encoding="UTF-8"?><Rowsets DateCreated="2015-09-22T16:24:47" EndDate="2014-11-26T12:17:44" StartDate="2014-11-26T12:17:44" Version="14.0 SP5 Patch 15 (Nov 20, 2014)">

    <Rowset>

        <Columns/>

        <Row>

            <_2013-01-01T00_00_00>395.52</_2013-01-01T00_00_00>

            <_2013-01-01T00_00_00>88.14</_2013-01-01T00_00_00>

            <_2013-01-02T00_00_00>483.42</_2013-01-02T00_00_00>

            <_2013-01-03T00_00_00>369.36</_2013-01-03T00_00_00>

Thanks

Muhammad Ashfaq

[former_member185280]

There are a lot of ways you can probably accomplish this but typically when manipulating xml using an xsl transform gets the best performance.

XSL Transformation

Regards,
Christian

[mashfaq]

Dear Christian,

      I use XSL but it did for only two column & give me result as below:

<?xml version="1.0" encoding="UTF-8"?><Rowsets DateCreated="2015-09-22T16:24:47" EndDate="2014-11-26T12:17:44" StartDate="2014-11-26T12:17:44" Version="14.0 SP5 Patch 15 (Nov 20, 2014)">

    <Rowset>

        <Columns/>

        <Row>

            <_2013-01-01T00_00_00>395.52</_2013-01-01T00_00_00>

            <_2013-01-01T00_00_00>88.14</_2013-01-01T00_00_00>

            <_2013-01-02T00_00_00>483.42</_2013-01-02T00_00_00>

            <_2013-01-03T00_00_00>369.36</_2013-01-03T00_00_00>

Thanks

Muhammad Ashfaq