Hi Kendall,
Yes, your solution works too (see query below). Really appreciate your help!
Best,
Ron
declare namespace e = "http://example.com";
declare function e:strip-namespaces($node as node()) as node() {
typeswitch ($node)
case $node as document-node() return document { $node/node()/e:strip-namespaces(.) }
case $node as element() return element {local-name($node)} { $node/@*, $node/node()/e:strip-namespaces(.) }
default return $node
};
for $drug in e:strip-namespaces(db:open('DrugBankFail'))/drugbank/drug
where not(empty($drug/atc-codes/atc-code))
return <drug> {
<ATC5> { string-join(distinct-values($drug/name), ' | ') } </ATC5>,
<ATC4> { string-join(distinct-values($drug/atc-codes/atc-code/level[string-length(@code) = 5]), ' | ') } </ATC4>,
<ATC3> { string-join(distinct-values($drug/atc-codes/atc-code/level[string-length(@code) = 4]), ' | ') } </ATC3>,
<ATC2> { string-join(distinct-values($drug/atc-codes/atc-code/level[string-length(@code) = 3]), ' | ') } </ATC2>,
<ATC1> { string-join(distinct-values($drug/atc-codes/atc-code/level[string-length(@code) = 1]), ' | ') } </ATC1>
} </drug>