Export to Excel-Graph Creation

[Mike J]

Dear All,

I'm having a mental block and cannot figure out how to get the data into rows instead of columns.

I have subjects that are weighed over time. I would like to export this so I can graph in excel.

I would like the data to export like this.

Subject 1 Weight (day 1) Weight (day 2) etc.

Subject 2 Weight (day 1) Weight (day 2) etc.

Any thoughts or advice?

Thanks

Mike

[mr_vodka]

http://fmforums.com/forum/showtopic.php?tid/194121

[comment]

This can be done by exporting XML with a custom-written XSLT stylesheet.

[Mike J]

Hi Comment,

Do you have a template I could try?

Thanks

[Mike J]

Hi John,

I take a look at the Pivot Tables. I guess as a developer this is easy, but makes it difficult for the end user that is not computer savvy to understand a pivot table.

Thanks for the links though.

Mike

[comment]

There is no template for this - it needs to be custom-written. Here's a simple demo.

(Run the script to export; keep the files together)

Export_Rows.zip

Edited December 4, 2008 by Guest

[bruceR]

No need for XML, it can be done with a calc field.

Export_Rows.zip

[comment]

No, I'm afraid that won't work: when you export in a tab-separated format, tabs in fields will be converted to spaces (you would have seen this if your script didn't use the XML).

[bruceR]

Drat, you're right again.

[Mike J]

Thanks comment! I will take a look and learn more about XML. I hope I can come back and expand on the question once I have a handle on the process.

Mike

[Mike J]

Thanks Bruce, I tried this already. Thanks for your input and any other ideas you may have about the topic.

Mike