Need XSL for below requirement

sbolchetwar · August 13th, 2014, 05:53 AM

Hi All,

I need XSL to translate below input xml into expected output xml.

Req. in brief
I have xml which has item element with attributes itemid and type, i need to segregate those item elements based on its type. Sample input and output is as below.

input

Code:

<cat>
	<catItem item="1" type="A" />
	<catItem item="2" type="A" />
	<catItem item="3" type="B" />
	<catItem item="4" type="B" />
</cat>

---------------------------------
expected output

Code:

<cat>
	<Category type="A">
		<Item id="1" />
		<Item id="2" />		
	</Category>
	<Category type="B">
		<Item id="3" />
		<Item id="4" />		
	</Category>
</cat>

Can any one help me to develop XSL for above requirement.

Thanks,
Sandeep

mhkay · August 13th, 2014, 07:02 AM

Is the possible set of values for "type" known in advance, or does it depend on what you find in the data?

sbolchetwar · August 13th, 2014, 10:39 AM

Firstly i would like to say thank you for the response.

"type" will not be available in advance, that could be possibly 1000's occurrences.

Thanks,
Sandeep B

mhkay · August 13th, 2014, 11:02 AM

In that case this is a standard grouping query. If you are using XSLT 2.0 look at the xsl:for-each-group instruction; with XSLT 1.0 look up "Muenchian grouping" which you will probably find in the index of your favourite Wrox XSLT textbook. The 1.0 solution appears complex but it's not difficult when you get the hang of it; it's much more straightforward in XSLT 2.0.