I am trying to output a parameter to a xls file
i am using the following cmd line
gdxxrw input=start.gdx o=ref2.xlsm par=neatthings rng=neatthings!a2
the output is working but can not find a way to do it without creating the crosstab.
1990 1991 1992
01_M 01_MN
01_M 02_MN
01_M 03_MN
01_M 06_MN
01_M 10_MN
02_M 01_MN
02_M 02_MN
02_M 03_MN
02_M 04_MN
02_M 05_MN
02_M 06_MN
02_M 10_MN
02_M 11_MN
03_M 01_MN
03_M 02_MN
03_M 03_MN
03_M 06_MN
03_M 10_MN
04_M 01_MN
04_M 02_MN
04_M 03_MN 294.555 318.645 326.675
What I want is
dim1 dim2 dim3 value
01_M 01_MN 1990 294.555
01_M 02_MN 1991 318.645
01_M 03_MN 1992 326.675
01_M 06_MN 1993 326.31
\
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
Hi Lessly
You can use Rdim=3, this means that you have 3 dimensions in the first 3 columns (you have Rdim=2 Cdim =1)
See the gdxutils-documentation for more information.
Cheers
Renger
\
Modelworks
Gewerbestrasse 15
3600 Thun – Switzerland
+41 79 818 53 73
Info@modelworks.ch
blog.modelworks.ch
From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Lessly Goudarzi
Sent: Donnerstag, 20. März 2014 22:53
To: gamsworld@googlegroups.com
Subject: non-cross tab output when using gdxxrw write to csv
I am trying to output a parameter to a xls file
i am using the following cmd line
gdxxrw input=start.gdx o=ref2.xlsm par=neatthings rng=neatthings!a2
the output is working but can not find a way to do it without creating the crosstab.
1990
1991
1992
01_M
01_MN
01_M
02_MN
01_M
03_MN
01_M
06_MN
01_M
10_MN
02_M
01_MN
02_M
02_MN
02_M
03_MN
02_M
04_MN
02_M
05_MN
02_M
06_MN
02_M
10_MN
02_M
11_MN
03_M
01_MN
03_M
02_MN
03_M
03_MN
03_M
06_MN
03_M
10_MN
04_M
01_MN
04_M
02_MN
04_M
03_MN
294.555
318.645
326.675
What I want is
dim1 dim2 dim3 value
01_M
01_MN
1990
294.555
01_M
02_MN
1991
318.645
01_M
03_MN
1992
326.675
01_M
06_MN
1993
326.31
\
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
Excellent, your instruction worded perfect.
Thanks!
On Thursday, March 20, 2014 5:53:14 PM UTC-4, Lessly Goudarzi wrote:
I am trying to output a parameter to a xls file
i am using the following cmd line
gdxxrw input=start.gdx o=ref2.xlsm par=neatthings rng=neatthings!a2
the output is working but can not find a way to do it without creating the crosstab.
1990 1991 1992
01_M 01_MN
01_M 02_MN
01_M 03_MN
01_M 06_MN
01_M 10_MN
02_M 01_MN
02_M 02_MN
02_M 03_MN
02_M 04_MN
02_M 05_MN
02_M 06_MN
02_M 10_MN
02_M 11_MN
03_M 01_MN
03_M 02_MN
03_M 03_MN
03_M 06_MN
03_M 10_MN
04_M 01_MN
04_M 02_MN
04_M 03_MN 294.555 318.645 326.675
What I want is
dim1 dim2 dim3 value
01_M 01_MN 1990 294.555
01_M 02_MN 1991 318.645
01_M 03_MN 1992 326.675
01_M 06_MN 1993 326.31
\
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.