
January 6th, 2011, 05:56 AM
|
|
Registered User
|
|
Join Date: Jan 2011
Posts: 1
Time spent in forums: 17 m 14 sec
Reputation Power: 0
|
|
|
XML conversion
Hi,
Could anyone please help me to convert XML to XML by using XSLT?
My input xml is:
<Root>
<Students>
<Student>
<RegId>12001</RegId>
<Absences>
<Absence>
<StartDate>2010-11-01</StartDate>
<EndDate>2010-11-02</EndDate>
<NoOfLeave>2</NoOfLeave>
<Category>SIC</Category>
</Absence>
<Absence>
<StartDate>2010-11-03</StartDate>
<EndDate>2010-11-03</EndDate>
<NoOfLeave>1</NoOfLeave>
<Category>SIC</Category>
</Absence>
<Absence>
<StartDate>2010-11-04</StartDate>
<EndDate>2010-11-04</EndDate>
<NoOfLeave>1</NoOfLeave>
<Category>SIC</Category>
</Absence>
<Absence>
<StartDate>2010-11-05</StartDate>
<EndDate>2010-11-05</EndDate>
<NoOfLeave>1</NoOfLeave>
<Category>TRN</Category>
</Absence>
<Absence>
<StartDate>2010-11-06</StartDate>
<EndDate>2010-11-06</EndDate>
<NoOfLeave>1</NoOfLeave>
<Category>SIC</Category>
</Absence>
</Absences>
</Student>
</Students>
</Root>
And, I want out in XML format (by using XSL) as follows:
<Root>
<Students>
<Student>
<RegId>12001</RegId>
<Absences>
<Absence>
<StartDate>2010-11-01</StartDate>
<EndDate>2010-11-04</EndDate>
<NoOfLeave>4</NoOfLeave>
<Category>SIC</Category>
</Absence>
<Absence>
<StartDate>2010-11-05</StartDate>
<EndDate>2010-11-05</EndDate>
<NoOfLeave>1</NoOfLeave>
<Category>TRN</Category>
</Absence>
<Absence>
<StartDate>2010-11-06</StartDate>
<EndDate>2010-11-06</EndDate>
<NoOfLeave>1</NoOfLeave>
<Category>SIC</Category>
</Absence>
</Absences>
</Student>
</Students>
</Root>
Thanks.
|