Oxygen XML Forum

Hi Team ,
Need your help to construct xslt version 1.0 for below xml which would find item which has same 'Name' attribute value (like 'Offer1') and get the item which has highest PACKAGE_ID value . For other unique items no action required

Only xslt 1.0 compatible

Sample Input :
<Item>
<Name>Offer2</Name>
<Price>0</Price>
<PACKAGE_ID>112602895</PACKAGE_ID>
</Item>
<Item>
<Name>Offer3</Name>
<Price>0</Price>
<PACKAGE_ID>112602895</PACKAGE_ID>
</Item>
<Item>
<Name>Offer1</Name>
<Price>0</Price>
<PACKAGE_ID>5</PACKAGE_ID>
</Item>
<Item>
<Name>Offer1</Name>
<Price>0</Price>
<PACKAGE_ID>4</PACKAGE_ID>
</Item>
<Item>
<Name>Offer1</Name>
<Price>0</Price>
<PACKAGE_ID>3</PACKAGE_ID>
</Item>
<Item>
<Name>Offer1</Name>
<Price>0</Price>
<PACKAGE_ID>2</PACKAGE_ID>
</Item>
<Item>
<Name>Offer1</Name>
<Price>0</Price>
<PACKAGE_ID>1</PACKAGE_ID>
</Item>
<Item>
<Name>Offer4</Name>
<Type>NCR</Type>
<QTY>1</QTY>
<PACKAGE_ID>112602895</PACKAGE_ID>
</Item>

Output:


<Item>
<Name>Offer2</Name>
<Price>0</Price>
<PACKAGE_ID>112602895</PACKAGE_ID>
</Item>
<Item>
<Name>Offer3</Name>
<Price>0</Price>
<PACKAGE_ID>112602895</PACKAGE_ID>
</Item>
<Item>
<Name>Offer1</Name>
<Price>0</Price>
<PACKAGE_ID>5</PACKAGE_ID>
</Item>

<Item>
<Name>Offer4</Name>
<Type>NCR</Type>
<QTY>1</QTY>
<PACKAGE_ID>112602895</PACKAGE_ID>
</Item>