export arrayed data with time all in one column

Use this forum to post Vensim related questions.
Post Reply
megboyar
Senior Member
Posts: 59
Joined: Mon Nov 16, 2009 7:22 am

export arrayed data with time all in one column

Post by megboyar »

Hi,

Is it possible within the data export settings to export all of the values @ times into one column:

variable[red,triangle] 2018 3.1416
variable [red, square] 2019 2.6834
variable[blue, triangle] 2018 -0.119
variable[blue,square] 2019 8.888


Thank you,
Sarah
megboyar
Senior Member
Posts: 59
Joined: Mon Nov 16, 2009 7:22 am

Re: export arrayed data with time all in one column

Post by megboyar »

Ok, I'm talking about a 'flat file'?

So, anyeway, I exported to a .txt file as 'data list format' and it's able to load into Excel the way i wish from that. Maybe a better way to do this? But it works.

Thank you,
Sarah
tomfid
Administrator
Posts: 4019
Joined: Wed May 24, 2006 4:54 am

Re: export arrayed data with time all in one column

Post by tomfid »

I think "data list" is what you want. You can automate with a command script if you're doing it repeatedly.
https://www.vensim.com/documentation/vdf2dlist.html
and if you want it to happen after every run, load the cmd script into the pre/post field
https://www.vensim.com/documentation/pr ... q=pre+post
Post Reply