help me with XSLT
Hi
I'm quite new to XSL.
I have some data on an existing XML format:
<Issue>
<IssueHistory_CreationDate>2004-01-01</IssueHistory_CreationDate>
<Status>
<Name>Fined</Name>
<Amount>28</Amount>
<Name>Solved</Name>
<Amount>0</Amount>
<Name>Finished</Name>
<Amount>0</Amount>
</Status>
<IssueHistory_CreationDate>2004-01-02</IssueHistory_CreationDate>
<Status>
<Name>Fined</Name>
<Amount>6</Amount>
<Name>Solved</Name>
<Amount>6</Amount>
<Name>Finished</Name>
<Amount>4</Amount>
</Status>
<IssueHistory_CreationDate>2004-01-03</IssueHistory_CreationDate>
<Status>
<Name>Fined</Name>
<Amount>2</Amount>
<Name>Solved</Name>
<Amount>6</Amount>
<Name>Finished</Name>
<Amount>4</Amount>
</Status>
<IssueHistory_CreationDate>2004-01-04</IssueHistory_CreationDate>
<Status>
<Name>Fined</Name>
<Amount>13</Amount>
<Name>Solved</Name>
<Amount>7</Amount>
<Name>Finished</Name>
<Amount>7</Amount>
</Status>
Now, I want to transform this into something like this:
<chart>
<chart_data>
<row>
<null/>
<string>2004-01-01</string>
<string>2004-01-02</string>
<string>2004-01-03</string>
<string>2004-01-04</string>
</row>
<row>
<string>Fined</string>
<number>28</number>
<number>6</number>
<number>2</number>
<number>13</number>
</row>
<row>
<string>Solved</string>
<number>0</number>
<number>6</number>
<number>6</number>
<number>7</number>
<row>
<string>Finished</string>
<number>0</number>
<number>4</number>
<number>4</number>
<number>7</number>
</row>
</chart_data>
</chart>
Does anyone know how I can translate this with XSLT?
Thanks!
|