rhino wrote:
Given that these are two separate XML files but that there is some common
information, specifically the department number, could I use XSLT to
generate a report that shows me each department name followed by the names
of the people who work in the department? Something like this:
Marketing
Department Number: 001
Location: New York
Manager: T. Jones
Other Staff
E. Humperdinck
E. Presley
J. Hendrix
Information Systems
Department Number: 666
Location: Toronto
Manager: M. Slate
Other Staff
F. Flintstone
B. Rubble
J. Rockhead
Just in case you (or someone else) might be interested in a non-XSLT solution:
here a small xgawk script that does the job.
$ cat departments.xml
<?xml version="1.0" encoding="UTF-8"?>
<departments>
<department>
<department_number>001</department_number>
<name>Marketing</name>
<location>New York</location>
<manager>T. Jones</manager>
</department>
<department>
<department_number>666</department_number>
<name>Information Systems</name>
<location>Toronto</location>
<manager>M. Slate</manager>
</department>
</departments>
$ cat employees.xml
<?xml version="1.0" encoding="UTF-8"?>
<employees>
<employee>
<name>E. Humperdinck</name>
<department_number>001</department_number>
</employee>
<employee>
<name>E. Presley</name>
<department_number>001</department_number>
</employee>
<employee>
<name>J. Hendrix</name>
<department_number>001</department_number>
</employee>
<employee>
<name>F. Flintstone</name>
<department_number>666</department_number>
</employee>
<employee>
<name>B. Rubble</name>
<department_number>666</department_number>
</employee>
<employee>
<name>J. Rockhead</name>
<department_number>666</department_number>
</employee>
</employees>
$ cat join.awk
@load xml
XMLSTARTELEM {data = "" ; next}
XMLCHARDATA {data = $0 ; next}
XMLDEPTH == 3 && XMLENDELEM {
a[XMLENDELEM] = data
dept = a["department_number"]
}
NR == FNR && XMLENDELEM == "employee" {
o[dept] = o[dept] sep[dept] " " a["name"]
sep[dept] = "\n"
next
}
XMLENDELEM == "department" {
print a["name"]
print " Department Number: " dept
print " Location: " a["location"]
print " Manager: " a["manager"]
print ORS " Other Staff" ORS o[dept] ORS
}
END {if (XMLERROR) print XMLERROR}
$ xgawk -f join.awk employees.xml departments.xml
Marketing
Department Number: 001
Location: New York
Manager: T. Jones
Other Staff
E. Humperdinck
E. Presley
J. Hendrix
Information Systems
Department Number: 666
Location: Toronto
Manager: M. Slate
Other Staff
F. Flintstone
B. Rubble
J. Rockhead
|