I have a sample xml below.
I want to do a distinct on the code node and the programDescription node.
I want the output to be like in a tree structure or in a nested 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 nested table structure
Thanks

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<ProgramDetail>
<Code>PRG004</Code>

<programDescription>Crazy Training 2</programDescription>

<CourseCode>MAT01</CourseCode>

<DurationHours>8</DurationHours>

<CourseDescription>Maths For Beginners</CourseDescription>

<ModuleCode>TEST101</ModuleCode>

<ModuleDescription>Test Module</ModuleDescription>
</ProgramDetail>

<ProgramDetail>
<Code>PRG004</Code>

<programDescription>Crazy Training 2</programDescription>

<CourseCode>PHS101</CourseCode>

<DurationHours>36</DurationHours>

<CourseDescription>Physics</CourseDescription>

<ModuleCode>TEST101</ModuleCode>

<ModuleDescription>Test Module</ModuleDescription>

<PreReqCourseCode>MAT234</PreReqCourseCode>
</ProgramDetail>

<ProgramDetail>
<Code>PRG004</Code>

<programDescription>Crazy Training 2</programDescription>

<CourseCode>PHS101</CourseCode>

<DurationHours>36</DurationHours>

<CourseDescription>Physics</CourseDescription>

<ModuleCode>TEST103</ModuleCode>

<ModuleDescription>TESTMODULEWITHLONGNAME</ModuleDescription>

<PreReqCourseCode>MAT234</PreReqCourseCode>
</ProgramDetail>

<ProgramDetail>
<Code>PRG005</Code>

<programDescription>Program 6</programDescription>

<CourseCode>COURSE102</CourseCode>

<DurationHours>5</DurationHours>

<CourseDescription>Course for learning Courses</CourseDescription>

<ModuleCode>MODULE101</ModuleCode>

<ModuleDescription>Module 1</ModuleDescription>
</ProgramDetail>

<ProgramDetail>
<Code>PRG005</Code>

<programDescription>Program 6</programDescription>

<CourseCode>MAT01</CourseCode>

<DurationHours>8</DurationHours>

<CourseDescription>Maths For Beginners</CourseDescription>

<ModuleCode>TEST101</ModuleCode>

<ModuleDescription>Test Module</ModuleDescription>
</ProgramDetail>

<ProgramDetail>
<Code>PRG005</Code>

<programDescription>Program 6</programDescription>

<CourseCode>MAT234</CourseCode>

<DurationHours>8</DurationHours>

<CourseDescription>Maths</CourseDescription>

<ModuleCode>TEST101</ModuleCode>

<ModuleDescription>Test Module</ModuleDescription>

<PreReqCourseCode>MAT01</PreReqCourseCode>
</ProgramDetail>

<ProgramDetail>
<Code>PRG005</Code>

<programDescription>Program 6</programDescription>

<CourseCode>MAT234</CourseCode>

<DurationHours>8</DurationHours>

<CourseDescription>Maths</CourseDescription>

<ModuleCode>TEST101</ModuleCode>

<ModuleDescription>Test Module</ModuleDescription>

<PreReqCourseCode>MAT101</PreReqCourseCode>
</ProgramDetail>

<ProgramDetail>
<Code>PRG005</Code>

<programDescription>Program 6</programDescription>

<CourseCode>MAT234</CourseCode>

<DurationHours>8</DurationHours>

<CourseDescription>Maths</CourseDescription>

<ModuleCode>TEST101</ModuleCode>

<ModuleDescription>Test Module</ModuleDescription>

<PreReqCourseCode>PHS101</PreReqCourseCode>
</ProgramDetail>

<ProgramDetail>
<Code>PRG005</Code>

<programDescription>Program 6</programDescription>

<CourseCode>MAT234</CourseCode>

<DurationHours>8</DurationHours>

<CourseDescription>Maths</CourseDescription>

<ModuleCode>TEST102</ModuleCode>

<ModuleDescription>TestModule2</ModuleDescription>

<PreReqCourseCode>MAT01</PreReqCourseCode>
</ProgramDetail>

<ProgramDetail>
<Code>PRG005</Code>

<programDescription>Program 6</programDescription>

<CourseCode>MAT234</CourseCode>

<DurationHours>8</DurationHours>

<CourseDescription>Maths</CourseDescription>

<ModuleCode>TEST102</ModuleCode>

<ModuleDescription>TestModule2</ModuleDescription>

<PreReqCourseCode>MAT101</PreReqCourseCode>
</ProgramDetail>

<ProgramDetail>
<Code>PRG005</Code>

<programDescription>Program 6</programDescription>

<CourseCode>MAT234</CourseCode>

<DurationHours>8</DurationHours>

<CourseDescription>Maths</CourseDescription>

<ModuleCode>TEST102</ModuleCode>

<ModuleDescription>TestModule2</ModuleDescription>

<PreReqCourseCode>PHS101</PreReqCourseCode>
</ProgramDetail>
</NewDataSet>