Read data Excel in an order

Question

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?

icon

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

View original

Chris Kuip · Accepted Answer

Hello,After reading in the second column into a string parameter, I'd use the following steps:For each row:Use StringOccurrences to determine the number of kommasUse FindNthSTring to determine the position of each kommaUse substring to select each letterUse StringToElement to map each letter to an elementUse += on an ordered set to append the found element to the set being constructed.I've enclosed a small working AIMMS 4.94 project.Let me knowif you have questions on the above.With kind regards,Chris

MZwanenburg · Answer

Hi @Chris Kuip,It worked! Thank you very much for the example.

Read data Excel in an order

2 replies

1 Attachment

Reply

1 Attachment

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded