ExcelActiveX atom
Posted: Monday 25 April, 2016 - 17:02
Hi,
We have a question concerning the ExcelActiveX atom.
We want to read the data in the Excel-file as inter-arrival times in the source atom.
In total, we have 112 data (so 112 rows and 1 column).
Now we say in the source atom in the inter-arrival time field that: MyTable(1,1) and MyTable is the alias name for our table. However, when we run the model, the source creates products according to the first row only, and repeats this 112 times. So it takes always the same inter-arrival time. How can we take all 112 different times as our inter-arrival time?
Kind regards
We have a question concerning the ExcelActiveX atom.
We want to read the data in the Excel-file as inter-arrival times in the source atom.
In total, we have 112 data (so 112 rows and 1 column).
Now we say in the source atom in the inter-arrival time field that: MyTable(1,1) and MyTable is the alias name for our table. However, when we run the model, the source creates products according to the first row only, and repeats this 112 times. So it takes always the same inter-arrival time. How can we take all 112 different times as our inter-arrival time?
Kind regards