I have an sample xml below.
I want to do a distinct on the code node and the programDescript ion.
I want the output to be like in a tree structure.
So i would like to have
PRG004 >Crazy Training 2> MAT01
PHS101
Any ideas it musn't be in a tree but it could be in a table structure
Thanks
<?xml version="1.0" standalone="yes "?>
<?xml-stylesheet type="text/xsl" href="email.xsl "?>
<NewDataSet>
<ProgramDetai l>
<Code>PRG004</Code>
<programDescrip tion>Crazy Training 2</programDescript ion>
<CourseCode>MAT 01</CourseCode>
<DurationHours> 8</DurationHours>
<CourseDescript ion>Maths For Beginners</CourseDescripti on>
<ModuleCode>TES T101</ModuleCode>
<ModuleDescript ion>Test Module</ModuleDescripti on>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG004</Code>
<programDescrip tion>Crazy Training 2</programDescript ion>
<CourseCode>PHS 101</CourseCode>
<DurationHours> 36</DurationHours>
<CourseDescript ion>Physics</CourseDescripti on>
<ModuleCode>TES T101</ModuleCode>
<ModuleDescript ion>Test Module</ModuleDescripti on>
<PreReqCourseCo de>MAT234</PreReqCourseCod e>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG004</Code>
<programDescrip tion>Crazy Training 2</programDescript ion>
<CourseCode>PHS 101</CourseCode>
<DurationHours> 36</DurationHours>
<CourseDescript ion>Physics</CourseDescripti on>
<ModuleCode>TES T103</ModuleCode>
<ModuleDescript ion>TESTMODULEW ITHLONGNAME</ModuleDescripti on>
<PreReqCourseCo de>MAT234</PreReqCourseCod e>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG005</Code>
<programDescrip tion>Program 6</programDescript ion>
<CourseCode>COU RSE102</CourseCode>
<DurationHours> 5</DurationHours>
<CourseDescript ion>Course for learning Courses</CourseDescripti on>
<ModuleCode>MOD ULE101</ModuleCode>
<ModuleDescript ion>Module 1</ModuleDescripti on>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG005</Code>
<programDescrip tion>Program 6</programDescript ion>
<CourseCode>MAT 01</CourseCode>
<DurationHours> 8</DurationHours>
<CourseDescript ion>Maths For Beginners</CourseDescripti on>
<ModuleCode>TES T101</ModuleCode>
<ModuleDescript ion>Test Module</ModuleDescripti on>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG005</Code>
<programDescrip tion>Program 6</programDescript ion>
<CourseCode>MAT 234</CourseCode>
<DurationHours> 8</DurationHours>
<CourseDescript ion>Maths</CourseDescripti on>
<ModuleCode>TES T101</ModuleCode>
<ModuleDescript ion>Test Module</ModuleDescripti on>
<PreReqCourseCo de>MAT01</PreReqCourseCod e>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG005</Code>
<programDescrip tion>Program 6</programDescript ion>
<CourseCode>MAT 234</CourseCode>
<DurationHours> 8</DurationHours>
<CourseDescript ion>Maths</CourseDescripti on>
<ModuleCode>TES T101</ModuleCode>
<ModuleDescript ion>Test Module</ModuleDescripti on>
<PreReqCourseCo de>MAT101</PreReqCourseCod e>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG005</Code>
<programDescrip tion>Program 6</programDescript ion>
<CourseCode>MAT 234</CourseCode>
<DurationHours> 8</DurationHours>
<CourseDescript ion>Maths</CourseDescripti on>
<ModuleCode>TES T101</ModuleCode>
<ModuleDescript ion>Test Module</ModuleDescripti on>
<PreReqCourseCo de>PHS101</PreReqCourseCod e>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG005</Code>
<programDescrip tion>Program 6</programDescript ion>
<CourseCode>MAT 234</CourseCode>
<DurationHours> 8</DurationHours>
<CourseDescript ion>Maths</CourseDescripti on>
<ModuleCode>TES T102</ModuleCode>
<ModuleDescript ion>TestModule2 </ModuleDescripti on>
<PreReqCourseCo de>MAT01</PreReqCourseCod e>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG005</Code>
<programDescrip tion>Program 6</programDescript ion>
<CourseCode>MAT 234</CourseCode>
<DurationHours> 8</DurationHours>
<CourseDescript ion>Maths</CourseDescripti on>
<ModuleCode>TES T102</ModuleCode>
<ModuleDescript ion>TestModule2 </ModuleDescripti on>
<PreReqCourseCo de>MAT101</PreReqCourseCod e>
</ProgramDetail>
<ProgramDetai l>
<Code>PRG005</Code>
<programDescrip tion>Program 6</programDescript ion>
<CourseCode>MAT 234</CourseCode>
<DurationHours> 8</DurationHours>
<CourseDescript ion>Maths</CourseDescripti on>
<ModuleCode>TES T102</ModuleCode>
<ModuleDescript ion>TestModule2 </ModuleDescripti on>
<PreReqCourseCo de>PHS101</PreReqCourseCod e>
</ProgramDetail>
</NewDataSet>