Array Issues

[zaguber]

Hi,

I am using Automation Anywhere 5.0 Integration Pack. I am using Two list variables Array1 and Array2. In previous version when i use the command below
1 Start Loop " List Variable Array1"
2 Message Box: "$Array1$"
3 Message Box: "$Array2$"
4 Comment: Please enter your commands to loop.
5 End Loop

IF the Both Array1 and Array2 moved to the next value. With the latest version Array1 moves to the next value where as array2 gives only the first value.
Please let me know if there is an option to move both variables to second value with each loopcounter.

Thanks
Syed

[forumsupport]

Hello,

If you wish to loop for these two list variables simultaneously i.e. in a single loop, items of both the list variables should increment then you will have to place the data in two columns of excel for e.g. Column1 would have ListVar1 items and Column2 would have ListVar2 items. Now, using Excel command (found under Applications command category), open that excel file (using Open Spreadsheet option), get all the data using Get Multiple Cells option and using 'Loop for each row in an Excel dataset' command get the data using $Excel Column$ variable. Whenever you have retrieved a range of cells from excel using Excel-> Get Cells->Get Multiple Cells., the rows and columns of the range are stored in the System Variable $Excel Column$ . Let's say you retrieved a range of cells from excel that have 2 columns. You can access the two columns of the table by calling $Excel Column(1)$, $Excel Column(2).

For your reference, we have attached a sample task in loop.zip. Please copy attached .atmn file under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. Copy Book1.xls under C:\ and run the task.

Hope that helps.