How to show each cell value to be shown as a new record

Here should go questions about transforming XML with XSLT and FOP.
deepag0303
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 » Fri Mar 05, 2021 1:13 am

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:
XSLT Help.jpg
XSLT Help.jpg (163.61 KiB) Viewed 128 times
Attachments
image.png
image.png (6.82 KiB) Viewed 128 times