Altova Mailing List Archives>Archive Index >microsoft.public.xsl Archive Home >Recent entries [Thread Prev] >Thread Next - Re: XSL question Re: XSL questionTo: NULL Date: 3/7/2006 1:51:00 PM If you change the way you construct this xml, then this will be so easily to do. You can change the xml to the bellow xml for example. <?xml version="1.0" standalone="yes"?> <?xml-stylesheet type="text/xsl" href="email.xsl"?> <NewDataSet> <ProgramDetail> <Item> <Code>PRG004</Code> <programDescription>Crazy Training 2</programDescription> <course> <CourseCode>MAT01</CourseCode> <DurationHours>8</DurationHours> <CourseDescription>Maths For Beginners</CourseDescription> <ModuleCode>TEST101</ModuleCode> <ModuleDescription>Test Module</ModuleDescription> </course> <course> <CourseCode>PHS101</CourseCode> <DurationHours>36</DurationHours> <CourseDescription>Physics</CourseDescription> <ModuleCode>TEST101</ModuleCode> <ModuleDescription>Test Module</ModuleDescription> <PreReqCourseCode>MAT234</PreReqCourseCode> </course> <course> <CourseCode>PHS101</CourseCode> <DurationHours>36</DurationHours> <CourseDescription>Physics</CourseDescription> <ModuleCode>TEST103</ModuleCode> <ModuleDescription>TESTMODULEWITHLONGNAME</ModuleDescription> <PreReqCourseCode>MAT234</PreReqCourseCode> </course> </Item> <Item> <Code>PRG005</Code> <programDescription>Program 6</programDescription> <course> <CourseCode>COURSE102</CourseCode> <DurationHours>5</DurationHours> <CourseDescription>Course for learning Courses</CourseDescription> <ModuleCode>MODULE101</ModuleCode> <ModuleDescription>Module 1</ModuleDescription> </course> <course> <CourseCode>MAT01</CourseCode> <DurationHours>8</DurationHours> <CourseDescription>Maths For Beginners</CourseDescription> <ModuleCode>TEST101</ModuleCode> <ModuleDescription>Test Module</ModuleDescription> </course> <course> <CourseCode>MAT234</CourseCode> <DurationHours>8</DurationHours> <CourseDescription>Maths</CourseDescription> <ModuleCode>TEST101</ModuleCode> <ModuleDescription>Test Module</ModuleDescription> <PreReqCourseCode>MAT01</PreReqCourseCode> </course> </Item> </ProgramDetail> </NewDataSet> "Patrick.O.Ige" <naijacoder@h...> wrote in message news:%23U%23mYn5NGHA.720@T...... >I have an sample xml below. > I want to do a distinct on the code node and the programDescription. > 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> > <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> > > > > | ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
