How to show each cell value to be shown as a new record
Here should go questions about transforming XML with XSLT and FOP.
-
- Posts: 2
- Joined: Thu Apr 11, 2019 4:27 am
How to show each cell value to be shown as a new record
Post by deepag0303 »
I am new to XSLT.
I have below xml and would like to write XSLT to achieve desired results. Can you someone help me with xslt:
Xml (Source):
<?xml version='1.0' encoding='UTF-8'?>
<wd:Report_Data xmlns:wd="urn:com.workday.report/Term">
<wd:Report_Entry>
<wd:Process wd:Descriptor="Approved Time Off">
<wd:ID wd:type="WID">87bc534385ae0146e7d4a79496017234</wd:ID>
</wd:Process>
<wd:Recurrence_Start_Date>2019-07-16-07:00</wd:Recurrence_Start_Date>
<wd:Recurrence_End_Date>2021-12-31-08:00</wd:Recurrence_End_Date>
<wd:EMI_Terminated_Workers>
<wd:Worker wd:Descriptor="ABC">
<wd:ID wd:type="WID">123</wd:ID>
<wd:ID wd:type="Employee_ID">123</wd:ID>
</wd:Worker>
<wd:EmpID>123</wd:EmpID>
</wd:EMI_Terminated_Workers>
<wd:EMI_Terminated_Workers>
<wd:Worker wd:Descriptor="XYZ">
<wd:ID wd:type="WID">456</wd:ID>
<wd:ID wd:type="Employee_ID">456</wd:ID>
</wd:Worker>
<wd:EmpID>456</wd:EmpID>
</wd:EMI_Terminated_Workers>
</wd:Report_Entry>
</wd:Report_Data>
Output should be:
I have below xml and would like to write XSLT to achieve desired results. Can you someone help me with xslt:
Xml (Source):
<?xml version='1.0' encoding='UTF-8'?>
<wd:Report_Data xmlns:wd="urn:com.workday.report/Term">
<wd:Report_Entry>
<wd:Process wd:Descriptor="Approved Time Off">
<wd:ID wd:type="WID">87bc534385ae0146e7d4a79496017234</wd:ID>
</wd:Process>
<wd:Recurrence_Start_Date>2019-07-16-07:00</wd:Recurrence_Start_Date>
<wd:Recurrence_End_Date>2021-12-31-08:00</wd:Recurrence_End_Date>
<wd:EMI_Terminated_Workers>
<wd:Worker wd:Descriptor="ABC">
<wd:ID wd:type="WID">123</wd:ID>
<wd:ID wd:type="Employee_ID">123</wd:ID>
</wd:Worker>
<wd:EmpID>123</wd:EmpID>
</wd:EMI_Terminated_Workers>
<wd:EMI_Terminated_Workers>
<wd:Worker wd:Descriptor="XYZ">
<wd:ID wd:type="WID">456</wd:ID>
<wd:ID wd:type="Employee_ID">456</wd:ID>
</wd:Worker>
<wd:EmpID>456</wd:EmpID>
</wd:EMI_Terminated_Workers>
</wd:Report_Entry>
</wd:Report_Data>
Output should be:
XSLT Help.jpg
You do not have the required permissions to view the files attached to this post.
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