Subject:Save results of XQuery as CSV? Author:Doug Lundin Date:28 Sep 2006 10:52 AM
I've been tinkering with this and can't seem to get it to work. Perhaps I'm making this change in the wrong place. I've got Stylus Enterprise opened with my xquery loaded. I open my scenario and when the Output URL is set to file:///c:/myfile.txt I get the expected output. When I change it to adapter:CSV?file:///c:/myfile.txt I get an empty file.
Subject:Save results of XQuery as CSV? Author:Tony Lavinio Date:03 Oct 2006 11:03 AM
I think you need one more level of element in your output.
In order to write through the CSV adapter, you need a root
element, and then a row element, and then column elements.
I tried a simple XQuery program that consisted of just this:
and I got just a CR/LF in my output file. The reason? No
root element - Stylus Studio just saw CompanyMetadata as the
root, and Col1 and Col2 as row names.
If I change it to
then I get
as my output.
Here is the output URL I used: