Hi,
I need to process and XML to create another XML with filtered data.
I have an XML as shown below:
<?xml version="1.0" encoding="UTF-8"?>
<DATA>
<DETAIL1>
<Name>John Smith</Name>
<Age>46</Age>
<Gender>Male</Gender>
<EmpNo>E0001</EmpNo>
</DETAIL1>
<Supervisors>
<SuperVisorLevel1>
<Name>John Smith</Name>
<Designation>Supervisor</Designation>
<Type>Internal</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Jane Doe</Name>
<Designation>Manager Level 1</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Howey Adams</Name>
<Designation>Manager Level 1</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Megan P</Name>
<Designation>HR manager</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>James</Name>
<Designation>Manager Level 2</Designation>
<Type>Internal</Type>
</SuperVisorLevel1>
</Supervisors>
</DATA>
I want to use XSL to change into an XML where only supervisors of type External XML are filtered.
<?xml version="1.0" encoding="UTF-8"?>
<DATA>
<DETAIL1>
<Name>John Smith</Name>
<Age>46</Age>
<Gender>Male</Gender>
<EmpNo>E0001</EmpNo>
</DETAIL1>
<Supervisors>
<SuperVisorLevel1>
<Name>Jane Doe</Name>
<Designation>Manager Level 1</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Howey Adams</Name>
<Designation>Manager Level 1</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Megan P</Name>
<Designation>HR manager</Designation>
<Type>External</Type>
</SuperVisorLevel1>
</Supervisors>
</DATA>
Please advice.
Thanks
goldie
I need to process and XML to create another XML with filtered data.
I have an XML as shown below:
<?xml version="1.0" encoding="UTF-8"?>
<DATA>
<DETAIL1>
<Name>John Smith</Name>
<Age>46</Age>
<Gender>Male</Gender>
<EmpNo>E0001</EmpNo>
</DETAIL1>
<Supervisors>
<SuperVisorLevel1>
<Name>John Smith</Name>
<Designation>Supervisor</Designation>
<Type>Internal</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Jane Doe</Name>
<Designation>Manager Level 1</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Howey Adams</Name>
<Designation>Manager Level 1</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Megan P</Name>
<Designation>HR manager</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>James</Name>
<Designation>Manager Level 2</Designation>
<Type>Internal</Type>
</SuperVisorLevel1>
</Supervisors>
</DATA>
I want to use XSL to change into an XML where only supervisors of type External XML are filtered.
<?xml version="1.0" encoding="UTF-8"?>
<DATA>
<DETAIL1>
<Name>John Smith</Name>
<Age>46</Age>
<Gender>Male</Gender>
<EmpNo>E0001</EmpNo>
</DETAIL1>
<Supervisors>
<SuperVisorLevel1>
<Name>Jane Doe</Name>
<Designation>Manager Level 1</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Howey Adams</Name>
<Designation>Manager Level 1</Designation>
<Type>External</Type>
</SuperVisorLevel1>
<SuperVisorLevel1>
<Name>Megan P</Name>
<Designation>HR manager</Designation>
<Type>External</Type>
</SuperVisorLevel1>
</Supervisors>
</DATA>
Please advice.
Thanks
goldie