Read data Excel in an order

  • 17 April 2023
  • 2 replies

Badge +4

Hi all, 

I want to read data from Excel but it should be sorted customly. 

In Excel the data is like this: 


The result in AIMMS should be this: 


I can create this with a text join in Excel and paste the value in the data field in AIMMS but the data changes frequently so I want to automate this with AXLL functions. It is important that the order of a, b and c holds. 


Does anyone have an idea to do this? 


Best answer by Chris Kuip 18 April 2023, 16:56

View original

2 replies

Userlevel 5
Badge +7



After reading in the second column into a string parameter, I'd use the following steps:

  • For each row:

I've enclosed a small working AIMMS 4.94 project.


Let me know if you have questions on the above.


With kind regards,


Badge +4

Hi @Chris Kuip , 

It worked! Thank you very much for the example. 



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

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