XSLT help for expected output
Here should go questions about transforming XML with XSLT and FOP.
-
- 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>
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>
Jump to
- Oxygen XML Editor/Author/Developer
- ↳ Feature Request
- ↳ Common Problems
- ↳ DITA (Editing and Publishing DITA Content)
- ↳ SDK-API, Frameworks - Document Types
- ↳ DocBook
- ↳ TEI
- ↳ XHTML
- ↳ Other Issues
- Oxygen XML Web Author
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Content Fusion
- ↳ Feature Request
- ↳ Common Problems
- Oxygen JSON Editor
- ↳ Feature Request
- ↳ Common Problems
- Oxygen PDF Chemistry
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Feedback
- ↳ Feature Request
- ↳ Common Problems
- Oxygen XML WebHelp
- ↳ Feature Request
- ↳ Common Problems
- XML
- ↳ General XML Questions
- ↳ XSLT and FOP
- ↳ XML Schemas
- ↳ XQuery
- NVDL
- ↳ General NVDL Issues
- ↳ oNVDL Related Issues
- XML Services Market
- ↳ Offer a Service