XSLT help for expected output

Here should go questions about transforming XML with XSLT and FOP.
dreampangari
Posts: 1
Joined: Fri Jul 08, 2022 3:18 pm

XSLT help for expected output

Post by dreampangari »

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>