Filter XML using XSL

wxdqz

New Member
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
 
Back
Top