I want filter through this xml first by “namer” then “lob” then “bay” then “place.” I can get to the first part but then I want the remaining information for that “namer.” For example: “namer” of value 0001a03 has “lob” of SBB “bay” of A1 and “place” of L. I know I can do this if I create “lob” as a child for “namer” but that is not a possibility. Can someone please help suggest what I can do? Thanks. XML below:
<lab>
<wks namer= “0001a03” lob = “SBB” bay =“A1” place =“L”/>
<wks namer= “0002a02” lob = “Counter” bay =“A2” place =“M”/>
<wks namer= “0003a01” lob = “Retail” bay =“A3” place =“R”/>
<wks namer= “0004a01” lob = “LPC” bay =“A4” place =“L”/>
<wks namer= “0005a01” lob = “Laptop” bay =“A5” place =“M”/>
<wks namer= “0006a01” lob = “Currency” bay =“A6” place =“M”/>
<wks namer= “0003a01” lob = “Counter” bay =“A7” place =“R”/>
<wks namer= “0008a01” lob = “SBB” bay =“A8” place =“L”/>
</lab>
