|
Subject: [xsl] xsl grouping help From: "Vanessa Pacheco" <vssequeira@xxxxxxxxx> Date: Fri, 8 Feb 2008 15:21:10 -0500 |
Hello,
I just joined this group a minute ago, so I hope I'm sending this
message to the right address. I'm a newbie and hence struggling :-(
I need help with grouping. I have the following xml file structure
<!-- Begin xml file -->
<Client>
<PersonID>
<PersonIDNum>1290</PersonIDNum>
</PersonID>
<Program>
<ClientHistory>
<IncomeCashSource>
<a>1</a>
<b>1.1</b>
<c>
<d>1.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>2</a>
<b>2.1</b>
<c>
<d>2.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>2</a>
<b>2.1</b>
<c>
<d>2.3</d>
</c>
</IncomeCashSource>
</ClientHistory>
</Program>
<Program>
<ClientHistory>
<IncomeCashSource>
<a>1</a>
<b>1.1</b>
<c>
<d>1.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>2</a>
<b>2.1</b>
<c>
<d>2.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>3</a>
<b>3.1</b>
<c>
<d>3.3</d>
</c>
</IncomeCashSource>
</ClientHistory>
</Program>
</Client>
<Client>
<PersonID>
<PersonIDNum>1291</PersonIDNum>
</PersonID>
<Program>
<ClientHistory>
<IncomeCashSource>
<a>1</a>
<b>1.1</b>
<c>
<d>1.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>2</a>
<b>2.1</b>
<c>
<d>2.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>4</a>
<b>4.1</b>
<c>
<d>4.3</d>
</c>
</IncomeCashSource>
</ClientHistory>
</Program>
<Program>
<ClientHistory>
<IncomeCashSource>
<a>1</a>
<b>1.1</b>
<c>
<d>1.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>2</a>
<b>2.1</b>
<c>
<d>2.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>3</a>
<b>3.1</b>
<c>
<d>3.3</d>
</c>
</IncomeCashSource>
</ClientHistory>
</Program>
</Client>
<!-- End xml file -->
I have to group similar 'IncomeCashSource' records (having values of
<a>, <d> the same), within and across Programs for a single Client.
The resulting file should look something like this
<Clients>
<Client>
<Id>1290</Id>
<IncomeCashSource>
<a>1</a>
<b>1.1</b>
<c>
<d>1.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>3</a>
<b>3.1</b>
<c>
<d>3.3</d>
</c>
</IncomeCashSource>
</Client>
<Client>
<Id>1291</Id>
<IncomeCashSource>
<a>1</a>
<b>1.1</b>
<c>
<d>1.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>2</a>
<b>2.1</b>
<c>
<d>2.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>4</a>
<b>4.1</b>
<c>
<d>4.3</d>
</c>
</IncomeCashSource>
<IncomeCashSource>
<a>3</a>
<b>3.1</b>
<c>
<d>3.3</d>
</c>
</IncomeCashSource>
</Client>
</Clients>
Please help. I'm exhausted and frustrated after trying for 2 days and
coming up with nothing
~Vanessa
| Current Thread |
|---|
|
| <- Previous | Index | Next -> |
|---|---|---|
| Re: [xsl] result-document error, R. Neville | Thread | RE: [xsl] xsl grouping help, Michael Kay |
| Re: [xsl] result-document error, Colin Paul Adams | Date | Re: [xsl] result-document error, Manfred Staudinger |
| Month |