Skip to main content
Solved

Import three-dimensional parameter from Excel

  • October 8, 2020
  • 1 reply
  • 202 views
T

Hi community,

I have a three-dimensional parameter I would like to import. I know how to import one- and two-dimensional parameters, but do not know how to do this one. The data is stored in excel (I have attachted a snapshot as illustration of the structure of the data), I can extract (with some formulas in excel) the range (AM3:AO32) from which i would like to import the data. I also know the number of products (6), number of locations (5) and number of time periods (3). 

Can someone help me out with this?

Best answer by gdiepen

Hi Thijs,

 

Looking at the data, I think you can use ReadTable function. You can find an explanation about the three ranges (row-header, column-header, data ) and how to import multi-dimensional data in the article:

https://how-to.aimms.com/Articles/122/122-AXLL-Library.html

 

Update: could be that your column AK must repeat the values instead of having the blanks you are currently having, not 100% sure

    1 reply

    gdiepen
    AIMMS Champ
    Forum|alt.badge.img+7
    • gdiepen
    • AIMMS Champ
    • 155 replies
    • Answer
    • October 8, 2020

    Hi Thijs,

     

    Looking at the data, I think you can use ReadTable function. You can find an explanation about the three ranges (row-header, column-header, data ) and how to import multi-dimensional data in the article:

    https://how-to.aimms.com/Articles/122/122-AXLL-Library.html

     

    Update: could be that your column AK must repeat the values instead of having the blanks you are currently having, not 100% sure


    Terms & ConditionsAccessibility statement

    Didn't find what you were looking for? Try searching on our documentation pages:

    AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator