Mimic pivot table using XSLT 1.0
1
I would like a pivot table that will show the following XML.
<Records reportTime24h="18:02" reportTime="06:02:56PM" reportDate="2018-11-24" reportTitle="Pivot table">
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1001</TestID>
<TestName>TRIGLYCERIDEN(501)</TestName>
<Total>91</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1003</TestID>
<TestName>UREUM(501)</TestName>
<Total>62</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1003</TestID>
<TestName>UREUM(501)</TestName>
<Total>1642</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1004</TestID>
<TestName>NATRIUM(501)</TestName>
<Total>72</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1004</TestID>
<TestName>NATRIUM(501)</TestName>
<Total>1929</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1005</TestID>
<TestName>KALIUM(501)</TestName>
<Total>72</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1005</TestID>
<TestName>KALIUM(501)</TestName>
<Total>1929</Total>
</Record>
</Records>
Here is what the table should look like.
The cross between rows and columns should be the Total xml node that corresponds to the data intersected.
Is this possible?
PD: I have tried to do this using muenchian grouping. However, I was not able to iterate of the data across colums effectively. For example, the logic was not able to handle nodes that only had data for one of the genders. I tried to check for data in the node to display a zero (0) but failed.
EDIT
To follow the commenters recommendation.
Here is the XSL file that I worked on. It accomplishes the desired result but it fails when a Test only has data for one gender. It will place the data on the first column, regardless of wheter the datum belongs to the columns (gender).
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="key-tests" match="Record" use="TestID" />
<xsl:key name="key-sex" match="Record" use="Sex" />
<xsl:key name="key-tests-sex" match="Record" use="concat(TestID,'::',Sex)" />
<xsl:template match="/Records">
<html>
<head>
<style>
body { font-family: monospace; }
table { border-collapse: collapse; font-size: 8pt; }
table thead { background-color: gainsboro; font-weight: bold; }
td,th { border: 1px solid gainsboro; padding: 3px; min-width: 26px; }
tbody td { text-align: right; }
</style>
</head>
<body>
<table>
<thead>
<tr>
<th>Sex</th>
<xsl:apply-templates select="Record[generate-id() = generate-id(key('key-sex',Sex)[1])]" mode="key-sex"/>
</tr>
</thead>
<tbody>
<xsl:apply-templates select="Record[generate-id() = generate-id(key('key-tests',TestID)[1])]" mode="key-tests"/>
<tr>
<th></th>
<th><xsl:value-of select="sum(key('key-sex','F')/Total)"/></th>
<th><xsl:value-of select="sum(key('key-sex','M')/Total)"/></th>
</tr>
</tbody>
</table>
</body>
</html>
</xsl:template>
<!--Row Data (totals)-->
<xsl:template match="Record" mode="key-tests-sex">
<td><xsl:value-of select="Total"/></td>
</xsl:template>
<!-- Doctors (HEADER ROW) -->
<xsl:template match="Record" mode="key-sex">
<th><xsl:value-of select="Sex"/></th>
</xsl:template>
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<xsl:apply-templates select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::',Sex))[1])]" mode="key-tests-sex"/>
</tr>
</xsl:template>
</xsl:stylesheet>
Here is the end result image. I only included the portion visible in the view port. It is about 3 pages long. But should be enough to get the idea of what I am trying to accomplish.
What's wrong with the picture
The count shown for Female (7) is actually the count for Male.
xml xslt pivot-table xslt-1.0 muenchian-grouping
asked Nov 24 '18 at 22:43
ivan quinteroivan quintero
9129
add a comment |
1
I would like a pivot table that will show the following XML.
<Records reportTime24h="18:02" reportTime="06:02:56PM" reportDate="2018-11-24" reportTitle="Pivot table">
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1001</TestID>
<TestName>TRIGLYCERIDEN(501)</TestName>
<Total>91</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1003</TestID>
<TestName>UREUM(501)</TestName>
<Total>62</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1003</TestID>
<TestName>UREUM(501)</TestName>
<Total>1642</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1004</TestID>
<TestName>NATRIUM(501)</TestName>
<Total>72</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1004</TestID>
<TestName>NATRIUM(501)</TestName>
<Total>1929</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1005</TestID>
<TestName>KALIUM(501)</TestName>
<Total>72</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1005</TestID>
<TestName>KALIUM(501)</TestName>
<Total>1929</Total>
</Record>
</Records>
Here is what the table should look like.
The cross between rows and columns should be the Total xml node that corresponds to the data intersected.
Is this possible?
PD: I have tried to do this using muenchian grouping. However, I was not able to iterate of the data across colums effectively. For example, the logic was not able to handle nodes that only had data for one of the genders. I tried to check for data in the node to display a zero (0) but failed.
EDIT
To follow the commenters recommendation.
Here is the XSL file that I worked on. It accomplishes the desired result but it fails when a Test only has data for one gender. It will place the data on the first column, regardless of wheter the datum belongs to the columns (gender).
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="key-tests" match="Record" use="TestID" />
<xsl:key name="key-sex" match="Record" use="Sex" />
<xsl:key name="key-tests-sex" match="Record" use="concat(TestID,'::',Sex)" />
<xsl:template match="/Records">
<html>
<head>
<style>
body { font-family: monospace; }
table { border-collapse: collapse; font-size: 8pt; }
table thead { background-color: gainsboro; font-weight: bold; }
td,th { border: 1px solid gainsboro; padding: 3px; min-width: 26px; }
tbody td { text-align: right; }
</style>
</head>
<body>
<table>
<thead>
<tr>
<th>Sex</th>
<xsl:apply-templates select="Record[generate-id() = generate-id(key('key-sex',Sex)[1])]" mode="key-sex"/>
</tr>
</thead>
<tbody>
<xsl:apply-templates select="Record[generate-id() = generate-id(key('key-tests',TestID)[1])]" mode="key-tests"/>
<tr>
<th></th>
<th><xsl:value-of select="sum(key('key-sex','F')/Total)"/></th>
<th><xsl:value-of select="sum(key('key-sex','M')/Total)"/></th>
</tr>
</tbody>
</table>
</body>
</html>
</xsl:template>
<!--Row Data (totals)-->
<xsl:template match="Record" mode="key-tests-sex">
<td><xsl:value-of select="Total"/></td>
</xsl:template>
<!-- Doctors (HEADER ROW) -->
<xsl:template match="Record" mode="key-sex">
<th><xsl:value-of select="Sex"/></th>
</xsl:template>
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<xsl:apply-templates select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::',Sex))[1])]" mode="key-tests-sex"/>
</tr>
</xsl:template>
</xsl:stylesheet>
Here is the end result image. I only included the portion visible in the view port. It is about 3 pages long. But should be enough to get the idea of what I am trying to accomplish.
What's wrong with the picture
The count shown for Female (7) is actually the count for Male.
xml xslt pivot-table xslt-1.0 muenchian-grouping
asked Nov 24 '18 at 22:43
ivan quinteroivan quintero
9129
The XML file's data and the table's data do not match. In this state it's impossible to answer your question; even aside the fact that you, by now, have not shown any own effort to solve this.
– zx485
Nov 24 '18 at 22:48
Hello @zx485. Thansk for replying. The table image I included is just used to illustrate the end result I wish to accoplish. It is not supposed to match the XML data I included. Also, the XML i copied in the question is just a fraction of the actual XML file I am using. Finally, please look at the the edited question in which you will find: - The XSL file I used, which almost accomplishes the desired goal. - I included an image of the resulting HTML file after applying the XSL posted Apologies for keeping information since this app deals with patient data.
– ivan quintero
Nov 25 '18 at 1:04
add a comment |
1
1
1
I would like a pivot table that will show the following XML.
<Records reportTime24h="18:02" reportTime="06:02:56PM" reportDate="2018-11-24" reportTitle="Pivot table">
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1001</TestID>
<TestName>TRIGLYCERIDEN(501)</TestName>
<Total>91</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1003</TestID>
<TestName>UREUM(501)</TestName>
<Total>62</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1003</TestID>
<TestName>UREUM(501)</TestName>
<Total>1642</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1004</TestID>
<TestName>NATRIUM(501)</TestName>
<Total>72</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1004</TestID>
<TestName>NATRIUM(501)</TestName>
<Total>1929</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1005</TestID>
<TestName>KALIUM(501)</TestName>
<Total>72</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1005</TestID>
<TestName>KALIUM(501)</TestName>
<Total>1929</Total>
</Record>
</Records>
Here is what the table should look like.
The cross between rows and columns should be the Total xml node that corresponds to the data intersected.
Is this possible?
PD: I have tried to do this using muenchian grouping. However, I was not able to iterate of the data across colums effectively. For example, the logic was not able to handle nodes that only had data for one of the genders. I tried to check for data in the node to display a zero (0) but failed.
EDIT
To follow the commenters recommendation.
Here is the XSL file that I worked on. It accomplishes the desired result but it fails when a Test only has data for one gender. It will place the data on the first column, regardless of wheter the datum belongs to the columns (gender).
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="key-tests" match="Record" use="TestID" />
<xsl:key name="key-sex" match="Record" use="Sex" />
<xsl:key name="key-tests-sex" match="Record" use="concat(TestID,'::',Sex)" />
<xsl:template match="/Records">
<html>
<head>
<style>
body { font-family: monospace; }
table { border-collapse: collapse; font-size: 8pt; }
table thead { background-color: gainsboro; font-weight: bold; }
td,th { border: 1px solid gainsboro; padding: 3px; min-width: 26px; }
tbody td { text-align: right; }
</style>
</head>
<body>
<table>
<thead>
<tr>
<th>Sex</th>
<xsl:apply-templates select="Record[generate-id() = generate-id(key('key-sex',Sex)[1])]" mode="key-sex"/>
</tr>
</thead>
<tbody>
<xsl:apply-templates select="Record[generate-id() = generate-id(key('key-tests',TestID)[1])]" mode="key-tests"/>
<tr>
<th></th>
<th><xsl:value-of select="sum(key('key-sex','F')/Total)"/></th>
<th><xsl:value-of select="sum(key('key-sex','M')/Total)"/></th>
</tr>
</tbody>
</table>
</body>
</html>
</xsl:template>
<!--Row Data (totals)-->
<xsl:template match="Record" mode="key-tests-sex">
<td><xsl:value-of select="Total"/></td>
</xsl:template>
<!-- Doctors (HEADER ROW) -->
<xsl:template match="Record" mode="key-sex">
<th><xsl:value-of select="Sex"/></th>
</xsl:template>
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<xsl:apply-templates select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::',Sex))[1])]" mode="key-tests-sex"/>
</tr>
</xsl:template>
</xsl:stylesheet>
Here is the end result image. I only included the portion visible in the view port. It is about 3 pages long. But should be enough to get the idea of what I am trying to accomplish.
What's wrong with the picture
The count shown for Female (7) is actually the count for Male.
xml xslt pivot-table xslt-1.0 muenchian-grouping
asked Nov 24 '18 at 22:43
ivan quinteroivan quintero
9129
I would like a pivot table that will show the following XML.
<Records reportTime24h="18:02" reportTime="06:02:56PM" reportDate="2018-11-24" reportTitle="Pivot table">
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1001</TestID>
<TestName>TRIGLYCERIDEN(501)</TestName>
<Total>91</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1003</TestID>
<TestName>UREUM(501)</TestName>
<Total>62</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1003</TestID>
<TestName>UREUM(501)</TestName>
<Total>1642</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1004</TestID>
<TestName>NATRIUM(501)</TestName>
<Total>72</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1004</TestID>
<TestName>NATRIUM(501)</TestName>
<Total>1929</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>F</Sex>
<TestID>1005</TestID>
<TestName>KALIUM(501)</TestName>
<Total>72</Total>
</Record>
<Record>
<Year>2017</Year>
<Month>11</Month>
<Sex>M</Sex>
<TestID>1005</TestID>
<TestName>KALIUM(501)</TestName>
<Total>1929</Total>
</Record>
</Records>
Here is what the table should look like.
The cross between rows and columns should be the Total xml node that corresponds to the data intersected.
Is this possible?
PD: I have tried to do this using muenchian grouping. However, I was not able to iterate of the data across colums effectively. For example, the logic was not able to handle nodes that only had data for one of the genders. I tried to check for data in the node to display a zero (0) but failed.
EDIT
To follow the commenters recommendation.
Here is the XSL file that I worked on. It accomplishes the desired result but it fails when a Test only has data for one gender. It will place the data on the first column, regardless of wheter the datum belongs to the columns (gender).
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="key-tests" match="Record" use="TestID" />
<xsl:key name="key-sex" match="Record" use="Sex" />
<xsl:key name="key-tests-sex" match="Record" use="concat(TestID,'::',Sex)" />
<xsl:template match="/Records">
<html>
<head>
<style>
body { font-family: monospace; }
table { border-collapse: collapse; font-size: 8pt; }
table thead { background-color: gainsboro; font-weight: bold; }
td,th { border: 1px solid gainsboro; padding: 3px; min-width: 26px; }
tbody td { text-align: right; }
</style>
</head>
<body>
<table>
<thead>
<tr>
<th>Sex</th>
<xsl:apply-templates select="Record[generate-id() = generate-id(key('key-sex',Sex)[1])]" mode="key-sex"/>
</tr>
</thead>
<tbody>
<xsl:apply-templates select="Record[generate-id() = generate-id(key('key-tests',TestID)[1])]" mode="key-tests"/>
<tr>
<th></th>
<th><xsl:value-of select="sum(key('key-sex','F')/Total)"/></th>
<th><xsl:value-of select="sum(key('key-sex','M')/Total)"/></th>
</tr>
</tbody>
</table>
</body>
</html>
</xsl:template>
<!--Row Data (totals)-->
<xsl:template match="Record" mode="key-tests-sex">
<td><xsl:value-of select="Total"/></td>
</xsl:template>
<!-- Doctors (HEADER ROW) -->
<xsl:template match="Record" mode="key-sex">
<th><xsl:value-of select="Sex"/></th>
</xsl:template>
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<xsl:apply-templates select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::',Sex))[1])]" mode="key-tests-sex"/>
</tr>
</xsl:template>
</xsl:stylesheet>
Here is the end result image. I only included the portion visible in the view port. It is about 3 pages long. But should be enough to get the idea of what I am trying to accomplish.
What's wrong with the picture
The count shown for Female (7) is actually the count for Male.
xml xslt pivot-table xslt-1.0 muenchian-grouping
xml xslt pivot-table xslt-1.0 muenchian-grouping
asked Nov 24 '18 at 22:43
ivan quinteroivan quintero
9129
asked Nov 24 '18 at 22:43
ivan quinteroivan quintero
9129
edited Nov 25 '18 at 1:23
ivan quintero
asked Nov 24 '18 at 22:43
ivan quinteroivan quintero
9129
asked Nov 24 '18 at 22:43
ivan quinteroivan quintero
9129
asked Nov 24 '18 at 22:43
ivan quinteroivan quintero
9129
9129
The XML file's data and the table's data do not match. In this state it's impossible to answer your question; even aside the fact that you, by now, have not shown any own effort to solve this.
– zx485
Nov 24 '18 at 22:48
Hello @zx485. Thansk for replying. The table image I included is just used to illustrate the end result I wish to accoplish. It is not supposed to match the XML data I included. Also, the XML i copied in the question is just a fraction of the actual XML file I am using. Finally, please look at the the edited question in which you will find: - The XSL file I used, which almost accomplishes the desired goal. - I included an image of the resulting HTML file after applying the XSL posted Apologies for keeping information since this app deals with patient data.
– ivan quintero
Nov 25 '18 at 1:04
add a comment |
The XML file's data and the table's data do not match. In this state it's impossible to answer your question; even aside the fact that you, by now, have not shown any own effort to solve this.
– zx485
Nov 24 '18 at 22:48
Hello @zx485. Thansk for replying. The table image I included is just used to illustrate the end result I wish to accoplish. It is not supposed to match the XML data I included. Also, the XML i copied in the question is just a fraction of the actual XML file I am using. Finally, please look at the the edited question in which you will find: - The XSL file I used, which almost accomplishes the desired goal. - I included an image of the resulting HTML file after applying the XSL posted Apologies for keeping information since this app deals with patient data.
– ivan quintero
Nov 25 '18 at 1:04
The XML file's data and the table's data do not match. In this state it's impossible to answer your question; even aside the fact that you, by now, have not shown any own effort to solve this.
– zx485
Nov 24 '18 at 22:48
The XML file's data and the table's data do not match. In this state it's impossible to answer your question; even aside the fact that you, by now, have not shown any own effort to solve this.
– zx485
Nov 24 '18 at 22:48
Hello @zx485. Thansk for replying. The table image I included is just used to illustrate the end result I wish to accoplish. It is not supposed to match the XML data I included. Also, the XML i copied in the question is just a fraction of the actual XML file I am using. Finally, please look at the the edited question in which you will find: - The XSL file I used, which almost accomplishes the desired goal. - I included an image of the resulting HTML file after applying the XSL posted Apologies for keeping information since this app deals with patient data.
– ivan quintero
Nov 25 '18 at 1:04
Hello @zx485. Thansk for replying. The table image I included is just used to illustrate the end result I wish to accoplish. It is not supposed to match the XML data I included. Also, the XML i copied in the question is just a fraction of the actual XML file I am using. Finally, please look at the the edited question in which you will find: - The XSL file I used, which almost accomplishes the desired goal. - I included an image of the resulting HTML file after applying the XSL posted Apologies for keeping information since this app deals with patient data.
– ivan quintero
Nov 25 '18 at 1:04
add a comment |
1 Answer
1
active
oldest
votes
1
Try to change the template matching Record for mode key-tests to
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','F'))[1])]/Total"/>
</td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','M'))[1])]/Total"/>
</td>
</tr>
</xsl:template>
That at least should fix the problem with the wrong relation of the number and the gender.
As in your real data the different values of the Sex element are not restricted to F and M you will need some way to process the unique values each time to create a td cell and inside then map to the relevant Record data so the template will become
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<xsl:variable name="testId" select="TestID"/>
<xsl:for-each select="$unique-genders">
<td>
<xsl:value-of select="key('key-tests', $testId)[generate-id() = generate-id(key('key-tests-sex',concat(TestID, '::', current()))[1])]/Total"/>
</td>
</xsl:for-each>
</tr>
</xsl:template>
with declarations
<xsl:key name="key-sex" match="Sex" use="." />
<xsl:variable name="unique-genders" select="//Sex[generate-id() = generate-id(key('key-sex', .)[1])]"/>
as done in https://xsltfiddle.liberty-development.net/3NzcBue/2
answered Nov 25 '18 at 14:03
Martin HonnenMartin Honnen
111k65976
Thanks for replying Martin. That worked, however, I need a way for the template to automatically accommodate new entries for Sex (e.g. Female - Pregnant). So the key passed to Sex cannot be fixed. Is this possible?
– ivan quintero
Nov 25 '18 at 14:49
1
See xsltfiddle.liberty-development.net/3NzcBue/2, I think you want respectively need to process the unique gender values each time to create atdand then inside map to the relevantRecordgroup if it exists. If the code in the link helps I will morph that into an answer later.
– Martin Honnen
Nov 25 '18 at 15:12
Martin, yes, that looks like exactly what I need. You are a life saver. I will try it as soon as I can. Thanks for helping.
– ivan quintero
Nov 25 '18 at 15:33
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53462994%2fmimic-pivot-table-using-xslt-1-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Try to change the template matching Record for mode key-tests to
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','F'))[1])]/Total"/>
</td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','M'))[1])]/Total"/>
</td>
</tr>
</xsl:template>
That at least should fix the problem with the wrong relation of the number and the gender.
As in your real data the different values of the Sex element are not restricted to F and M you will need some way to process the unique values each time to create a td cell and inside then map to the relevant Record data so the template will become
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<xsl:variable name="testId" select="TestID"/>
<xsl:for-each select="$unique-genders">
<td>
<xsl:value-of select="key('key-tests', $testId)[generate-id() = generate-id(key('key-tests-sex',concat(TestID, '::', current()))[1])]/Total"/>
</td>
</xsl:for-each>
</tr>
</xsl:template>
with declarations
<xsl:key name="key-sex" match="Sex" use="." />
<xsl:variable name="unique-genders" select="//Sex[generate-id() = generate-id(key('key-sex', .)[1])]"/>
as done in https://xsltfiddle.liberty-development.net/3NzcBue/2
answered Nov 25 '18 at 14:03
Martin HonnenMartin Honnen
111k65976
Thanks for replying Martin. That worked, however, I need a way for the template to automatically accommodate new entries for Sex (e.g. Female - Pregnant). So the key passed to Sex cannot be fixed. Is this possible?
– ivan quintero
Nov 25 '18 at 14:49
1
See xsltfiddle.liberty-development.net/3NzcBue/2, I think you want respectively need to process the unique gender values each time to create atdand then inside map to the relevantRecordgroup if it exists. If the code in the link helps I will morph that into an answer later.
– Martin Honnen
Nov 25 '18 at 15:12
Martin, yes, that looks like exactly what I need. You are a life saver. I will try it as soon as I can. Thanks for helping.
– ivan quintero
Nov 25 '18 at 15:33
add a comment |
1
Try to change the template matching Record for mode key-tests to
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','F'))[1])]/Total"/>
</td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','M'))[1])]/Total"/>
</td>
</tr>
</xsl:template>
That at least should fix the problem with the wrong relation of the number and the gender.
As in your real data the different values of the Sex element are not restricted to F and M you will need some way to process the unique values each time to create a td cell and inside then map to the relevant Record data so the template will become
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<xsl:variable name="testId" select="TestID"/>
<xsl:for-each select="$unique-genders">
<td>
<xsl:value-of select="key('key-tests', $testId)[generate-id() = generate-id(key('key-tests-sex',concat(TestID, '::', current()))[1])]/Total"/>
</td>
</xsl:for-each>
</tr>
</xsl:template>
with declarations
<xsl:key name="key-sex" match="Sex" use="." />
<xsl:variable name="unique-genders" select="//Sex[generate-id() = generate-id(key('key-sex', .)[1])]"/>
as done in https://xsltfiddle.liberty-development.net/3NzcBue/2
answered Nov 25 '18 at 14:03
Martin HonnenMartin Honnen
111k65976
Thanks for replying Martin. That worked, however, I need a way for the template to automatically accommodate new entries for Sex (e.g. Female - Pregnant). So the key passed to Sex cannot be fixed. Is this possible?
– ivan quintero
Nov 25 '18 at 14:49
1
See xsltfiddle.liberty-development.net/3NzcBue/2, I think you want respectively need to process the unique gender values each time to create atdand then inside map to the relevantRecordgroup if it exists. If the code in the link helps I will morph that into an answer later.
– Martin Honnen
Nov 25 '18 at 15:12
Martin, yes, that looks like exactly what I need. You are a life saver. I will try it as soon as I can. Thanks for helping.
– ivan quintero
Nov 25 '18 at 15:33
add a comment |
1
1
1
Try to change the template matching Record for mode key-tests to
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','F'))[1])]/Total"/>
</td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','M'))[1])]/Total"/>
</td>
</tr>
</xsl:template>
That at least should fix the problem with the wrong relation of the number and the gender.
As in your real data the different values of the Sex element are not restricted to F and M you will need some way to process the unique values each time to create a td cell and inside then map to the relevant Record data so the template will become
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<xsl:variable name="testId" select="TestID"/>
<xsl:for-each select="$unique-genders">
<td>
<xsl:value-of select="key('key-tests', $testId)[generate-id() = generate-id(key('key-tests-sex',concat(TestID, '::', current()))[1])]/Total"/>
</td>
</xsl:for-each>
</tr>
</xsl:template>
with declarations
<xsl:key name="key-sex" match="Sex" use="." />
<xsl:variable name="unique-genders" select="//Sex[generate-id() = generate-id(key('key-sex', .)[1])]"/>
as done in https://xsltfiddle.liberty-development.net/3NzcBue/2
answered Nov 25 '18 at 14:03
Martin HonnenMartin Honnen
111k65976
Try to change the template matching Record for mode key-tests to
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','F'))[1])]/Total"/>
</td>
<td>
<xsl:value-of select="key('key-tests',TestID)[generate-id() = generate-id(key('key-tests-sex',concat(TestID,'::','M'))[1])]/Total"/>
</td>
</tr>
</xsl:template>
That at least should fix the problem with the wrong relation of the number and the gender.
As in your real data the different values of the Sex element are not restricted to F and M you will need some way to process the unique values each time to create a td cell and inside then map to the relevant Record data so the template will become
<!-- Tests (ROWS) -->
<xsl:template match="Record" mode="key-tests">
<tr>
<td><xsl:value-of select="TestName"/></td>
<xsl:variable name="testId" select="TestID"/>
<xsl:for-each select="$unique-genders">
<td>
<xsl:value-of select="key('key-tests', $testId)[generate-id() = generate-id(key('key-tests-sex',concat(TestID, '::', current()))[1])]/Total"/>
</td>
</xsl:for-each>
</tr>
</xsl:template>
with declarations
<xsl:key name="key-sex" match="Sex" use="." />
<xsl:variable name="unique-genders" select="//Sex[generate-id() = generate-id(key('key-sex', .)[1])]"/>
as done in https://xsltfiddle.liberty-development.net/3NzcBue/2
answered Nov 25 '18 at 14:03
Martin HonnenMartin Honnen
111k65976
edited Nov 25 '18 at 16:03
answered Nov 25 '18 at 14:03
Martin HonnenMartin Honnen
111k65976
answered Nov 25 '18 at 14:03
Martin HonnenMartin Honnen
111k65976
answered Nov 25 '18 at 14:03
Martin HonnenMartin Honnen
111k65976
111k65976
Thanks for replying Martin. That worked, however, I need a way for the template to automatically accommodate new entries for Sex (e.g. Female - Pregnant). So the key passed to Sex cannot be fixed. Is this possible?
– ivan quintero
Nov 25 '18 at 14:49
1
See xsltfiddle.liberty-development.net/3NzcBue/2, I think you want respectively need to process the unique gender values each time to create atdand then inside map to the relevantRecordgroup if it exists. If the code in the link helps I will morph that into an answer later.
– Martin Honnen
Nov 25 '18 at 15:12
Martin, yes, that looks like exactly what I need. You are a life saver. I will try it as soon as I can. Thanks for helping.
– ivan quintero
Nov 25 '18 at 15:33
add a comment |
Thanks for replying Martin. That worked, however, I need a way for the template to automatically accommodate new entries for Sex (e.g. Female - Pregnant). So the key passed to Sex cannot be fixed. Is this possible?
– ivan quintero
Nov 25 '18 at 14:49
1
See xsltfiddle.liberty-development.net/3NzcBue/2, I think you want respectively need to process the unique gender values each time to create atdand then inside map to the relevantRecordgroup if it exists. If the code in the link helps I will morph that into an answer later.
– Martin Honnen
Nov 25 '18 at 15:12
Martin, yes, that looks like exactly what I need. You are a life saver. I will try it as soon as I can. Thanks for helping.
– ivan quintero
Nov 25 '18 at 15:33
Thanks for replying Martin. That worked, however, I need a way for the template to automatically accommodate new entries for Sex (e.g. Female - Pregnant). So the key passed to Sex cannot be fixed. Is this possible?
– ivan quintero
Nov 25 '18 at 14:49
Thanks for replying Martin. That worked, however, I need a way for the template to automatically accommodate new entries for Sex (e.g. Female - Pregnant). So the key passed to Sex cannot be fixed. Is this possible?
– ivan quintero
Nov 25 '18 at 14:49
1
1
See xsltfiddle.liberty-development.net/3NzcBue/2, I think you want respectively need to process the unique gender values each time to create a
td and then inside map to the relevant Record group if it exists. If the code in the link helps I will morph that into an answer later.– Martin Honnen
Nov 25 '18 at 15:12
See xsltfiddle.liberty-development.net/3NzcBue/2, I think you want respectively need to process the unique gender values each time to create a
td and then inside map to the relevant Record group if it exists. If the code in the link helps I will morph that into an answer later.– Martin Honnen
Nov 25 '18 at 15:12
Martin, yes, that looks like exactly what I need. You are a life saver. I will try it as soon as I can. Thanks for helping.
– ivan quintero
Nov 25 '18 at 15:33
Martin, yes, that looks like exactly what I need. You are a life saver. I will try it as soon as I can. Thanks for helping.
– ivan quintero
Nov 25 '18 at 15:33
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53462994%2fmimic-pivot-table-using-xslt-1-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
The XML file's data and the table's data do not match. In this state it's impossible to answer your question; even aside the fact that you, by now, have not shown any own effort to solve this.
– zx485
Nov 24 '18 at 22:48
Hello @zx485. Thansk for replying. The table image I included is just used to illustrate the end result I wish to accoplish. It is not supposed to match the XML data I included. Also, the XML i copied in the question is just a fraction of the actual XML file I am using. Finally, please look at the the edited question in which you will find: - The XSL file I used, which almost accomplishes the desired goal. - I included an image of the resulting HTML file after applying the XSL posted Apologies for keeping information since this app deals with patient data.
– ivan quintero
Nov 25 '18 at 1:04