'Traverse XML Document in XSLT to Determine Value Match

Is it possible to use the XML below to do the following

For Each Report Entry Output: Employee_ID,wd:Legal_First_Name,wd:Legal_Last_Name

Then when wd:CF_Worker_Dependent_Spouse_Instance_group/wd:Legal_Name_-_First_Name != '' and wd:CF_Worker_Dependent_Spouse_Instance_group/wd:Spouse_SSN does not equal another wd:Worker_SSN in the file, Output: Employee_ID-s,wd:CF_Worker_Dependent_Spouse_Instance_group/wd:Legal_Name_-_First_Name,wd:CF_Worker_Dependent_Spouse_Instance_group/wd:Legal_Name_-_Last_Name

Requirement - Print a record for each employee and a dependent record for each dependent spouse that is not also an employee.

<wd:Report_Data>
  <wd:Report_Entry>
    <wd:Employee_ID>34050</wd:Employee_ID>
    <wd:CF_Worker_Dependent_Spouse_Instance_group>
    <wd:Legal_Name_-_First_Name>JANE</wd:Legal_Name_-_First_Name>
    <wd:Legal_Name_-_Last_Name>DOE</wd:Legal_Name_-_Last_Name>
    <wd:Spouse_SSN>222222222</wd:Spouse_SSN>
  </wd:CF_Worker_Dependent_Spouse_Instance_group>
  <wd:Worker_group>
    <wd:CF_On_Healthcare_Elections>Yes</wd:CF_On_Healthcare_Elections>
    <wd:Worker_SSN>111111111</wd:Worker_SSN>
  </wd:Worker_group>
  <wd:Legal_First_Name>John</wd:Legal_First_Name>
    <wd:Legal_Last_Name>Doe</wd:Legal_Last_Name>
  </wd:Report_Entry>

  <wd:Report_Entry>
    <wd:Employee_ID>37000</wd:Employee_ID>
    <wd:Worker_group>
    <wd:Worker_SSN>222222222</wd:Worker_SSN>
  </wd:Worker_group>
  <wd:Legal_First_Name>Jane</wd:Legal_First_Name>
    <wd:Legal_Last_Name>Doe</wd:Legal_Last_Name>
  </wd:Report_Entry>
</wd:Report_Data>
xmlxslttransformationsiblings


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions