Group XML message based on a particular sequence

Lipsita · March 9th, 2016, 09:19 AM

Input XML

<?xml version="1.0" encoding="UTF-8"?>
<Languages>
<Language>
<Language>German</Language>
<Proficiency>Native</Proficiency>
</Language>
<Language>
<Language>English</Language>
<Proficiency>Data Migration</Proficiency>
</Language>
<Language>
<Language>English</Language>
<Proficiency>Business</Proficiency>
</Language>
<Language>
<Language>French</Language>
<Proficiency>Conversational</Proficiency>
</Language>
</Languages>

Output XML

<?xml version="1.0" encoding="UTF-8"?>
<Languages>
<Language>
<Language>German</Language>
<Proficiency>Native</Proficiency>
</Language>
<Language>
<Language>English</Language>
<Proficiency>Business</Proficiency>
</Language>
<Language>
<Language>French</Language>
<Proficiency>Conversational</Proficiency>
</Language>
<Language>
<Language>English</Language>
<Proficiency>Data Migration</Proficiency>
</Language>
</Languages>

Need to form the xml such as the sequence of XML tags comes like Native,Business,Conversational and then Data Migration.

I was using the below code but its not working as expected

<?xml version="1.0" encoding="utf-8"?>

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xsl:output method="xml" indent="yes"/>

<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="xs:sequence[parent::xs:complexType/@name='Languages']">
<xsl:copy>
<xsl:apply-templates select="xs:element[@ref='Native']"/>
<xsl:apply-templates select="xs:element[@ref='Business']"/>
<xsl:apply-templates select="xs:element[@ref='Conversational']"/>
<xsl:apply-templates select="xs:element[@ref='Data Migration']"/>
</xsl:copy>
</xsl:template>

</xsl:stylesheet>

samjudson · March 9th, 2016, 10:11 AM

Not sure if the schema based approach is something that would work, but basically your template is not matching, so everything is going through the identity template.

The following gives the correct output.

Code:

 <xsl:template match="Languages">
      <xsl:copy>
         <xsl:apply-templates select="*[Proficiency='Native']"/>
         <xsl:apply-templates select="*[Proficiency='Business']"/>
         <xsl:apply-templates select="*[Proficiency='Conversational']"/>
         <xsl:apply-templates select="*[Proficiency='Data Migration']"/>
      </xsl:copy>
   </xsl:template>

You could change Proficiency to * to match on any child node irrespective of name.

mhkay · March 9th, 2016, 10:29 AM

Code:

<xsl:template match="xs:sequence[parent::xs:complexType/@name='Languages']">

This is completely muddled, I don't know where you got this idea from. You are processing the instance document, with element names like Language and Profiency. Element names like xs:sequence and xs:complexType are found only in the schema.