declare namespace a = "http://developer.cognos.com/schemas/xmldata/1/"; declare option ddtek:serialize "indent=yes"; declare function local:name($doc, $p as xs:integer) { translate($doc/a:dataset/a:metadata/a:item[$p]/@name, ' /', '') }; { for $row in /a:dataset/a:data/a:row return( for $value at $p in $row/a:value return element {local:name(/, $p)} { $value/string() } ) }(: Stylus Studio meta-information - (c) 2004-2009. Progress Software Corporation. All rights reserved. :)