I have an Xml file and XSL o format it below.
I have tried to distinct the "ProgramCod e" and the "programDescrip tion"
attributes but after that i still get repeatable data of
CourseCode,Cour seDescription etc
ANy helps
XML file
---------
<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type="text/xsl" href="new_email .xsl"?>
<Program>
<ProgramsDetail s ProgramCode="PR G004" programDescript ion="Crazy
Training 2">
<Course CourseCode="MAT 01" DurationHours=" 8"
CourseDescripti on="Maths For Beginners">
<Module ModuleCode="TES T101" ModuleDescripti on="Test Module" />
</Course>
<Prerequisite s PreReqCourseCod e="" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G004" programDescript ion="Crazy
Training 2">
<Course CourseCode="PHS 101" DurationHours=" 36"
CourseDescripti on="Physics">
<Module ModuleCode="TES T101" ModuleDescripti on="Test Module" />
</Course>
<Prerequisite s PreReqCourseCod e="MAT234" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G004" programDescript ion="Crazy
Training 2">
<Course CourseCode="PHS 101" DurationHours=" 36"
CourseDescripti on="Physics">
<Module ModuleCode="TES T103"
ModuleDescripti on="TESTMODULEW ITHLONGNAME" />
</Course>
<Prerequisite s PreReqCourseCod e="MAT234" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G005" programDescript ion="Program 6">
<Course CourseCode="COU RSE102" DurationHours=" 5"
CourseDescripti on="Course for learning Courses">
<Module ModuleCode="MOD ULE101" ModuleDescripti on="Module 1" />
</Course>
<Prerequisite s PreReqCourseCod e="" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G005" programDescript ion="Program 6">
<Course CourseCode="MAT 01" DurationHours=" 8"
CourseDescripti on="Maths For Beginners">
<Module ModuleCode="TES T101" ModuleDescripti on="Test Module" />
</Course>
<Prerequisite s PreReqCourseCod e="" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G005" programDescript ion="Program 6">
<Course CourseCode="MAT 234" DurationHours=" 8"
CourseDescripti on="Maths">
<Module ModuleCode="TES T101" ModuleDescripti on="Test Module" />
</Course>
<Prerequisite s PreReqCourseCod e="MAT01" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G005" programDescript ion="Program 6">
<Course CourseCode="MAT 234" DurationHours=" 8"
CourseDescripti on="Maths">
<Module ModuleCode="TES T101" ModuleDescripti on="Test Module" />
</Course>
<Prerequisite s PreReqCourseCod e="MAT101" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G005" programDescript ion="Program 6">
<Course CourseCode="MAT 234" DurationHours=" 8"
CourseDescripti on="Maths">
<Module ModuleCode="TES T101" ModuleDescripti on="Test Module" />
</Course>
<Prerequisite s PreReqCourseCod e="PHS101" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G005" programDescript ion="Program 6">
<Course CourseCode="MAT 234" DurationHours=" 8"
CourseDescripti on="Maths">
<Module ModuleCode="TES T102" ModuleDescripti on="TestModule2 " />
</Course>
<Prerequisite s PreReqCourseCod e="MAT01" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G005" programDescript ion="Program 6">
<Course CourseCode="MAT 234" DurationHours=" 8"
CourseDescripti on="Maths">
<Module ModuleCode="TES T102" ModuleDescripti on="TestModule2 " />
</Course>
<Prerequisite s PreReqCourseCod e="MAT101" />
</ProgramsDetails >
<ProgramsDetail s ProgramCode="PR G005" programDescript ion="Program 6">
<Course CourseCode="MAT 234" DurationHours=" 8"
CourseDescripti on="Maths">
<Module ModuleCode="TES T102" ModuleDescripti on="TestModule2 " />
</Course>
<Prerequisite s PreReqCourseCod e="PHS101" />
</ProgramsDetails >
</Program>
Xsl file:-
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" indent="yes" />
<xsl:key name="progs" match="Programs Details" use="@ProgramCo de" />
<xsl:key name="progs1" match="Programs Details" use="@ProgramCo de" />
<xsl:template match="Program" >
<xsl:for-each
select="Program sDetails[count(.|key('pr ogs',@ProgramCo de)[1]) = 1]">
<xsl:sort select="@progra mDescription" />
<xsl:value-of select="@Progra mCode" /><br />
<hr size="1"/>
<xsl:value-of select="@progra mDescription" /><br />
<br/>
<b>Course Code:</b>
<xsl:value-of select="Course/@CourseCode"/><br />
<xsl:for-each select="key('pr ogs', @ProgramCode)">
<xsl:sort select="Course/@CourseCode"/>
<b><xsl:value-of select="Course/@CourseCode"/>,</b> (<b><xsl:value-of
select="Course/@CourseDescript ion"/></b>)<br />
<br />
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
*** Sent via Developersdex http://www.developersdex.com ***