XSLT Transform - Repeating Attributes and Grouping Inquiry

BivsAi · February 29th, 2012, 02:10 PM

I have been struggling with an issue for a personal project that has me stumped and could use suggestions. What I am needing to do is construct a table that has the column @name as the headers but then the @values of the respected headers underneath. The challenges I am facing is that I need the existing XML to be separated/repeated into separate row elements so that each row only contains the associated column names + new values for Month_ID and Year as shown in the results XML being targeted.

Code:

<?xml version="1.0"?>
<?xml-stylesheet type="txt/xsl" href="transform.xsl"?>
<Report>
<ReportData>
<DataSet>
<Row rowNum="1">
<Column name="Title 1"><Val xsi:type="xsd:string">Sample 1</Val></Column>
<Column name="Title 2"><Val xsi:type="xsd:string">Sample 2</Val></Column>
<Column name="Title 3"><Val xsi:type="xsd:string">Sample 3</Val></Column>
<Column name="Title 4"><Val xsi:type="xsd:string">Sample 4</Val></Column>
<Column name="Title 5"><Val xsi:type="xsd:string">160X600</Val></Column>
<Column name="Title 6"><Val xsi:type="xsd:string" xsi:nil="true"></Val></Column>
<Column name="Title 7"><Val xsi:type="xsd:integer">1325600</Val></Column>
<Column name="MAR_Month_Total"><Val xsi:type="xsd:float">19.00</Val></Column>
<Column name="MAR_Month_Total_B"><Val xsi:type="xsd:float">22.00</Val></Column>
<Column name="APR_Month_Total"><Val xsi:type="xsd:float">18.00</Val></Column>
<Column name="APR_Month_Total_B"><Val xsi:type="xsd:float">35.00</Val></Column>
<Column name="MAY_Month_Total"><Val xsi:type="xsd:float">25.00</Val></Column>
<Column name="MAY_Month_Total_B"><Val xsi:type="xsd:float">15.00</Val></Column>
</Row>
<RowNum="2">
<Column name="Title 1"><Val xsi:type="xsd:string">Sample 5</Val></Column>
<Column name="Title 2"><Val xsi:type="xsd:string">Sample 6</Val></Column>
<Column name="Title 3"><Val xsi:type="xsd:string">Sample 7</Val></Column>
<Column name="Title 4"><Val xsi:type="xsd:string">Sample 8</Val></Column>
<Column name="Title 5"><Val xsi:type="xsd:string">250X600</Val></Column>
<Column name="Title 6"><Val xsi:type="xsd:string" xsi:nil="true"></Val></Column>
<Column name="Title 7"><Val xsi:type="xsd:integer">5600</Val></Column>
<Column name="MAR_Month_Total"><Val xsi:type="xsd:float">0.00</Val></Column>
<Column name="MAR_Month_Total_B"><Val xsi:type="xsd:float">5.00</Val></Column>
<Column name="APR_Month_Total"><Val xsi:type="xsd:float">24.00</Val></Column>
<Column name="APR_Month_Total_B"><Val xsi:type="xsd:float">10.00</Val></Column>
<Column name="MAY_Month_Total"><Val xsi:type="xsd:float">36.00</Val></Column>
<Column name="MAY_Month_Total_B"><Val xsi:type="xsd:float">15.00</Val></Column></Row>
</DataSet>
</ReportData>
</Report>

Targeted Results file in XML format

Code:

<?xml version="1.0"?>
<?xml-stylesheet type="txt/xsl" href="transform.xsl"?>
<Report>
<ReportData>
<DataSet>
<Row rowNum="1">
<Column name="Title 1"><Val xsi:type="xsd:string">Sample 1</Val></Column>
<Column name="Title 2"><Val xsi:type="xsd:string">Sample 2</Val></Column>
<Column name="Title 3"><Val xsi:type="xsd:string">Sample 3</Val></Column>
<Column name="Title 4"><Val xsi:type="xsd:string">Sample 4</Val></Column>
<Column name="Title 5"><Val xsi:type="xsd:string">160X600</Val></Column>
<Column name="Title 6"><Val xsi:type="xsd:string" xsi:nil="true"></Val></Column>
<Column name="Title 7"><Val xsi:type="xsd:integer">1325600</Val></Column>
<Column name="MAR_Month_ID"><Val xsi:type="xsd:integer">3</Val></Column>
<Column name="YEAR"><Val xsi:type="xsd:integer">2012</Val></Column>
<Column name="MAR_Month_Total"><Val xsi:type="xsd:float">19.00</Val></Column>
<Column name="MAR_Month_Total_B"><Val xsi:type="xsd:float">22.00</Val></Column>
</Row>
<Row rowNum="2">
<Column name="Title 1"><Val xsi:type="xsd:string">Sample 1</Val></Column>
<Column name="Title 2"><Val xsi:type="xsd:string">Sample 2</Val></Column>
<Column name="Title 3"><Val xsi:type="xsd:string">Sample 3</Val></Column>
<Column name="Title 4"><Val xsi:type="xsd:string">Sample 4</Val></Column>
<Column name="Title 5"><Val xsi:type="xsd:string">160X600</Val></Column>
<Column name="Title 6"><Val xsi:type="xsd:string" xsi:nil="true"></Val></Column>
<Column name="Title 7"><Val xsi:type="xsd:integer">1325600</Val></Column>
<Column name="APR_Month_ID"><Val xsi:type="xsd:integer">4</Val></Column>
<Column name="YEAR"><Val xsi:type="xsd:integer">2012</Val></Column>
<Column name="APR_Month_Total"><Val xsi:type="xsd:float">18.00</Val></Column>
<Column name="APR_Month_Total_B"><Val xsi:type="xsd:float">35.00</Val></Column>
</Row>
<Row rowNum="3">
<Column name="Title 1"><Val xsi:type="xsd:string">Sample 1</Val></Column>
<Column name="Title 2"><Val xsi:type="xsd:string">Sample 2</Val></Column>
<Column name="Title 3"><Val xsi:type="xsd:string">Sample 3</Val></Column>
<Column name="Title 4"><Val xsi:type="xsd:string">Sample 4</Val></Column>
<Column name="Title 5"><Val xsi:type="xsd:string">160X600</Val></Column>
<Column name="Title 6"><Val xsi:type="xsd:string" xsi:nil="true"></Val></Column>
<Column name="Title 7"><Val xsi:type="xsd:integer">1325600</Val></Column>
<Column name="MAY_Month_ID"><Val xsi:type="xsd:integer">5</Val></Column>
<Column name="YEAR"><Val xsi:type="xsd:integer">2012</Val></Column>
<Column name="MAY_Month_Total"><Val xsi:type="xsd:float">25.00</Val></Column>
<Column name="MAY_Month_Total_B"><Val xsi:type="xsd:float">15.00</Val></Column>
</Row>
<Row RowNum="4">
<Column name="Title 1"><Val xsi:type="xsd:string">Sample 5</Val></Column>
<Column name="Title 2"><Val xsi:type="xsd:string">Sample 6</Val></Column>
<Column name="Title 3"><Val xsi:type="xsd:string">Sample 7</Val></Column>
<Column name="Title 4"><Val xsi:type="xsd:string">Sample 8</Val></Column>
<Column name="Title 5"><Val xsi:type="xsd:string">250X600</Val></Column>
<Column name="Title 6"><Val xsi:type="xsd:string" xsi:nil="true"></Val></Column>
<Column name="Title 7"><Val xsi:type="xsd:integer">5600</Val></Column>
<Column name="MAR_Month_ID"><Val xsi:type="xsd:integer">3</Val></Column>
<Column name="YEAR"><Val xsi:type="xsd:integer">2012</Val></Column>
<Column name="MAR_Month_Total"><Val xsi:type="xsd:float">0.00</Val></Column>
<Column name="MAR_Month_Total_B"><Val xsi:type="xsd:float">5.00</Val></Column>
</Row>
<Row RowNum="5">
<Column name="Title 1"><Val xsi:type="xsd:string">Sample 5</Val></Column>
<Column name="Title 2"><Val xsi:type="xsd:string">Sample 6</Val></Column>
<Column name="Title 3"><Val xsi:type="xsd:string">Sample 7</Val></Column>
<Column name="Title 4"><Val xsi:type="xsd:string">Sample 8</Val></Column>
<Column name="Title 5"><Val xsi:type="xsd:string">250X600</Val></Column>
<Column name="Title 6"><Val xsi:type="xsd:string" xsi:nil="true"></Val></Column>
<Column name="Title 7"><Val xsi:type="xsd:integer">5600</Val></Column>
<Column name="APR_Month_ID"><Val xsi:type="xsd:integer">4</Val></Column>
<Column name="YEAR"><Val xsi:type="xsd:integer">2012</Val></Column>
<Column name="APR_Month_Total"><Val xsi:type="xsd:float">18.00</Val></Column>
<Column name="APR_Month_Total_B"><Val xsi:type="xsd:float">35.00</Val></Column>
</Row>
<Row rowNum"6">
<Column name="Title 1"><Val xsi:type="xsd:string">Sample 5</Val></Column>
<Column name="Title 2"><Val xsi:type="xsd:string">Sample 6</Val></Column>
<Column name="Title 3"><Val xsi:type="xsd:string">Sample 7</Val></Column>
<Column name="Title 4"><Val xsi:type="xsd:string">Sample 8</Val></Column>
<Column name="Title 5"><Val xsi:type="xsd:string">250X600</Val></Column>
<Column name="Title 6"><Val xsi:type="xsd:string" xsi:nil="true"></Val></Column>
<Column name="Title 7"><Val xsi:type="xsd:integer">5600</Val></Column>
<Column name="MAY_Month_ID"><Val xsi:type="xsd:integer">5</Val></Column>
<Column name="YEAR"><Val xsi:type="xsd:integer">2012</Val></Column>
<Column name="MAY_Month_Total"><Val xsi:type="xsd:float">18.00</Val></Column>
<Column name="MAY_Month_Total_B"><Val xsi:type="xsd:float">35.00</Val></Column>
</ROW>
</DataSet>
</ReportData>
</Report>

Any help or hints would be greatly appreciated. I have purchased books and researched areas but still stumped.
Thanks