Hello,
I am attempting to parse an XSLT file, and need to split it up to compare on a given variable. How can I do this? Example below:
If the XSLT file appeared like this:
<?xml version="1.0" encoding="UTF-16"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/xpath-functions" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<xsl:variable name="Names">
<xsl:choose>
<xsl:when test="John">
<xsl:value-of select="10"/>
</xsl:when>
<xsl:when test="Jack">
<xsl:value-of select="12"/>
</xsl:when>
<xsl:when test="James">
<xsl:value-of select="14"/>
</xsl:when>
<xsl:when test="Jim">
<xsl:value-of select="16"/>
</xsl:when>
<xsl:when test="Joe">
<xsl:value-of select="18"/>
</xsl:when>
<xsl:when test="Juan">
<xsl:value-of select="19"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="21"/>
</xsl:otherwise>
</xsl:choose>
<xsl:choose>
<xsl:when test="John">
<xsl:value-of select="44"/>
</xsl:when>
<xsl:when test="Jack">
<xsl:value-of select="36"/>
</xsl:when>
<xsl:when test="James">
<xsl:value-of select="98"/>
</xsl:when>
<xsl:when test="Jim">
<xsl:value-of select="54"/>
</xsl:when>
<xsl:when test="Joe">
<xsl:value-of select="142"/>
</xsl:when>
<xsl:when test="Juan">
<xsl:value-of select="10"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="65"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
</xsl:stylesheet>
Could I specify "</xsl:choose>" as the variable I want to break up and portion my file by? So the output, in Alteryx, would appear something like the following:
| </xsl:choose> |
<xsl:choose>
<xsl:when test="John">
<xsl:value-of select="10"/>
</xsl:when>
<xsl:when test="Jack">
<xsl:value-of select="12"/>
</xsl:when>
<xsl:when test="James">
<xsl:value-of select="14"/>
</xsl:when>
<xsl:when test="Jim">
<xsl:value-of select="16"/>
</xsl:when>
<xsl:when test="Joe">
<xsl:value-of select="18"/>
</xsl:when>
<xsl:when test="Juan">
<xsl:value-of select="19"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="21"/>
</xsl:otherwise>
</xsl:choose> |
</xsl:choose>
<xsl:choose>
<xsl:when test="John">
<xsl:value-of select="44"/>
</xsl:when>
<xsl:when test="Jack">
<xsl:value-of select="36"/>
</xsl:when>
<xsl:when test="James">
<xsl:value-of select="98"/>
</xsl:when>
<xsl:when test="Jim">
<xsl:value-of select="54"/>
</xsl:when>
<xsl:when test="Joe">
<xsl:value-of select="142"/>
</xsl:when>
<xsl:when test="Juan">
<xsl:value-of select="10"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="65"/>
</xsl:otherwise>
</xsl:choose> |
I'm unsure whether to read the file in as a CSV or XML initially, any help would be greatly appreciated!
Many thanks.
PLEASE NOTE: I COULD NOT UPLOAD THE XSLT FILE AS IS NOT ACCEPTED. APOLOGIES.
