On 1. Sep 2017, at 19:41, Ron Katriel rkatriel@mdsol.com wrote: Is there a way simpler way around this - other than modifying the input header to remove the namespace declaration?
Hi Ron,
declaring a default element in your XQuery might help?
```xquery declare default element namespace "http://www.drugbank.ca";
for $drug in doc('drugbank.Lepirudin.ATC.fail.xml')/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(for $level in $drug/atc-codes/atc-code/level return if (fn:string-length($level/@code) = 5) then $level/text() else ()), ' | ') } </ATC4>, <ATC3> { string-join(distinct-values(for $level in $drug/atc-codes/atc-code/level return if (fn:string-length($level/@code) = 4) then $level/text() else ()), ' | ') } </ATC3>, <ATC2> { string-join(distinct-values(for $level in $drug/atc-codes/atc-code/level return if (fn:string-length($level/@code) = 3) then $level/text() else ()), ' | ') } </ATC2>, <ATC1> { string-join(distinct-values(for $level in $drug/atc-codes/atc-code/level return if (fn:string-length($level/@code) = 1) then $level/text() else ()), ' | ') } </ATC1> } </drug>
```
Cheers, Alex