Page 1 of 1

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

Posted: Fri Mar 05, 2021 1:13 am
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:
XSLT Help.jpg
XSLT Help.jpg (163.61 KiB) Viewed 1808 times