[ad_1]
\n<\/p>\n
Just as a different approach and also handling the colours for the same bus_types. For every location, the location is set as classname to the Note: In the linked example I’ve only added one row for Texas to show that the XSLT displays multiple locations, only sets the season for the first one, and will also work in case not all colors are provided for a location. And the output is not valid HTML (no html-, head-, body-tags etc provided). As you mentioned you’d like to get HTML ouput, you probably already have an XSLT generating valid HTML where you can adjust\/include the part you need for the table.<\/p>\n Update<\/strong> for the question in the comments: To set the class name for a Change this in above XSLT:<\/p>\n into<\/p>\n Updated Demo 2<\/a> for this. <\/p>\n Additional notes and questions: One adjustment to the OP XML was to change the lowercase “volvo” to “Volvo”. In case the original export from DB really mixes upper- and lowercase names, this can be handled in the XSLT to lowercase all bus_names (to get the unique values) and uppercase the first letter for the value in the Update 2<\/strong> for the second question in the comments: I can add an (almost) line by line explanation and will drop a comment when done. I assume it’s not necessary to cover the HTML part but only the XSLT. In the meantime, as you mentioned you’re new to XSLT, maybe the following can be of use: Note that it should be avoided at SO to have extended comments – when there are too many comments below a post, an automated message will be displayed that suggests to move to chat. Because you need a reputation of 20 to chat (https:\/\/stackoverflow.com\/help\/privileges), this won’t be possible at the moment.<\/p>\n<\/p><\/div>\n
Demo<\/a><\/p>\n<?xml version=\"1.0\"?>\n<xsl:stylesheet\nxmlns:xsl=\"http:\/\/www.w3.org\/1999\/XSL\/Transform\" version=\"1.0\">\n<xsl:output method=\"html\"\/>\n<xsl:template match=\"https:\/\/stackoverflow.com\/\">\n<table>\n <tr>\n <td colspan=\"9\">ACME BUS SERVICE<\/td>\n <\/tr>\n <tr>\n <td colspan=\"9\">\n Month: <xsl:value-of select=\"\/\/Month\"\/>\n <\/td>\n <\/tr>\n <tr>\n <td>Season<\/td>\n <td>Location<\/td>\n <td>Bus Name<\/td>\n <td colspan=\"2\">RED<\/td>\n <td colspan=\"2\">GREEN<\/td>\n <td colspan=\"2\">BLUE<\/td>\n <\/tr>\n <tr>\n <td><\/td>\n <td><\/td>\n <td><\/td>\n <td>Bus Type<\/td>\n <td>Bus Count<\/td>\n <td>Bus Type<\/td>\n <td>Bus Count<\/td>\n <td>Bus Type<\/td>\n <td>Bus Count<\/td>\n <\/tr>\n <xsl:for-each select=\"\/\/row[Location[not(preceding::Location\/. = .)]]\" >\n <xsl:variable name=\"currentLocation\" select=\".\/Location\"\/>\n <tr>\n <xsl:attribute name=\"class\">\n <xsl:value-of select=\"$currentLocation\"\/>\n <\/xsl:attribute>\n <td>\n <xsl:if test=\"position()=1\">Winter<\/xsl:if>\n <\/td>\n <td>\n <xsl:value-of select=\"$currentLocation\"\/>\n <\/td>\n <td>\n <xsl:value-of select=\".\/bus_name\"\/>\n <\/td>\n <td>\n <xsl:if test=\"count(\/\/row[Location= $currentLocation]\n [bus_type = \/\/row[Location= $currentLocation]\n [bus_colour=\"red\"]\/bus_type]) > 1\">\n <xsl:attribute name=\"class\">color<\/xsl:attribute>\n <\/xsl:if>\n <xsl:value-of select=\"\/\/row[Location= $currentLocation]\n [bus_colour=\"red\"]\/bus_type\"\/>\n <\/td>\n <td>\n <xsl:value-of select=\"\/\/row[Location= $currentLocation]\n [bus_colour=\"red\"]\/bus_count\"\/>\n <\/td>\n <td>\n <xsl:if test=\"count(\/\/row[Location= $currentLocation]\n [bus_type = \/\/row[Location=$currentLocation] \n [bus_colour=\"green\"]\/bus_type]) > 1\">\n <xsl:attribute name=\"class\">color<\/xsl:attribute>\n <\/xsl:if>\n <xsl:value-of select=\"\/\/row[Location= $currentLocation]\n [bus_colour=\"green\"]\/bus_type\"\/>\n <\/td>\n <td>\n <xsl:value-of select=\"\/\/row[Location= $currentLocation]\n [bus_colour=\"green\"]\/bus_count\"\/>\n <\/td>\n <td>\n <xsl:if test=\"count(\/\/row[Location= $currentLocation]\n [bus_type = \/\/row[Location=$currentLocation] \n [bus_colour=\"blue\"]\/bus_type]) > 1\">\n <xsl:attribute name=\"class\">color<\/xsl:attribute>\n <\/xsl:if>\n <xsl:value-of select=\"\/\/row[Location= $currentLocation]\n [bus_colour=\"blue\"]\/bus_type\"\/>\n <\/td>\n <td>\n <xsl:value-of select=\"\/\/row[Location= $currentLocation]\n [bus_colour=\"blue\"]\/bus_count\"\/>\n <\/td>\n <\/tr>\n <\/xsl:for-each>\n<\/table>\n<\/xsl:template>\n<\/xsl:stylesheet>\n<\/code><\/pre>\n<tr><\/code>, e.g. <tr class=\"kansas\"><\/code>. Every td with a bus type that is used more than once at a location gets the class=”color”. So to display the table with different colors, you can just add CSS like e.g. .kansas .color { background-color: blue; }<\/code>. In case you want to display the same color based on the bus_type, just adjust the classname “color” in the xslt to the current bus_type. <\/p>\n<tr><\/code> to the name of the bus_type (in case a bus_type is used more than once at a location) instead of the location: <\/p>\n<tr>\n<xsl:attribute name=\"class\">\n <xsl:value-of select=\"$currentLocation\"\/>\n<\/xsl:attribute>\n<\/code><\/pre>\n<tr>\n<xsl:if test=\"count(\/\/row[Location=$currentLocation]) > \n count(\/\/row[Location=$currentLocation]\/\n bus_type[not(. = preceding::bus_type)])\"> \n <xsl:attribute name=\"class\">\n <xsl:value-of select=\"\/\/row[Location=$currentLocation]\/\n bus_type[ . = preceding::bus_type]\"\/>\n <\/xsl:attribute>\n<\/xsl:if>\n<\/code><\/pre>\n<td><\/code>. Also it would be good to know if you use XSLT 2.0 or XSLT 1.0 as XSLT 2.0 provides functionality to simplify some tasks – e.g. 2.0 provides a lower-case()<\/code> function where in 1.0 the same can be achieved using translate()<\/code> – as reference for this as you mentioned you’re new to XSL: How can I convert a string to upper- or lower-case with XSLT?
\nFurther question is – as the XML example is only a part of the DB export – if there will be only one row for each location or if it is possible that there are various rows, e.g. kansas bus1, kansas bus2 etc. <\/p>\n
\nfor <xsl:template match=\"https:\/\/stackoverflow.com\/\"><\/code> – https:\/\/stackoverflow.com\/questions\/3127108\/xsl-xsltemplate-match
\n
\nfor XPath axes – http:\/\/www.xmlplease.com\/axis<\/a>
\nfor some basics, e.g. – In what order do templates in an XSLT document execute, and do they match on the source XML or the buffered output? <\/p>\n