Page 1 of 1

Get data xls with multiple subscripts

Posted: Wed Jan 10, 2024 4:57 pm
by thifei
Hello,

Is it possible to import data as in this exemple http://www.vensim.com/documentation/fn_ ... _data.html, but with multiple subscripts?
I only manage to import with one subscript.

Reffering to this example, is it possible to import all values from B5 to B10 directly in a variable Sales[shape,size] for instance, with autonomous differenciation of the shapes and the sizes?

thanks in advance!

Re: Get data xls with multiple subscripts

Posted: Wed Jan 10, 2024 5:12 pm
by Administrator
Can you get the sample models working? They should import more than 1 subscript.

Re: Get data xls with multiple subscripts

Posted: Wed Jan 10, 2024 5:27 pm
by thifei
I attached the files where I tried the example, can you tell me how to do pls?

Re: Get data xls with multiple subscripts

Posted: Wed Jan 10, 2024 5:42 pm
by tomfid
The GET DATA calls are basically 1-dimensional because the spreadsheet is 2D, and one is taken by time.

One possible way to semi-automate a GET call with more dimensions is to put the sheet names or first-cell references in a string variable with the appropriate subscripting.

Re: Get data xls with multiple subscripts

Posted: Wed Jan 10, 2024 5:44 pm
by tomfid
In a case like this, importing the data to vdf would be less error-prone.