Hi Vensim users,
We are noticing that when using the command VDF2TIDY (described here https://www.vensim.com/documentation/vdf2tidy.html) it doesn't want to export data from a Vensim run if a given variable is defined as DATA. So effectively one has to create a passthrough variable of AUXILLIARY type that has the same information as in the DATA variable to export the data to CSV.
Thanks for any advice,
Paweł Olejarnik
VDF2TIDY
Re: VDF2TIDY
I think that may have been a deliberate choice, because data variables can have an arbitrary time axis, not matching the model. That would really increase the size of the tidy matrix.
What's the use case for exporting the data from the simulation, rather than using the input data?
What's the use case for exporting the data from the simulation, rather than using the input data?
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Re: VDF2TIDY
Thanks tomfid.
In regards to "What's the use case for exporting the data from the simulation, rather than using the input data?"
if you have the data in Excel, it goes into your vensim Model for example as a DATA variable. You then want to store it in the DW, so you use the export option of VDF2TIDY. So like that you can store what went into the model as INPUT and eventually do comparison how INPUTS change, etc. type of work once you store data. Effectively there can be cases where an input to a model is already and output of the model as no changes are done to the data in run time.
In regards to "What's the use case for exporting the data from the simulation, rather than using the input data?"
if you have the data in Excel, it goes into your vensim Model for example as a DATA variable. You then want to store it in the DW, so you use the export option of VDF2TIDY. So like that you can store what went into the model as INPUT and eventually do comparison how INPUTS change, etc. type of work once you store data. Effectively there can be cases where an input to a model is already and output of the model as no changes are done to the data in run time.
Re: VDF2TIDY
VDF2TAB might be a better choice for this.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/