Making list varibles random

[tech180]

Hello, I purchased automation anywhere and need to make list variable load randomly from a text file. Is this possible? Thanks for your help

[forumsupport]

Hello,

Currently it is not possible to load list variable randomly.

However, what you can do is instead of text file, you can write the list of values in one column. Let's say column A and let's say you have 50 values.

Create a random variable that ranges from 1 to 50.

And then in go to cell command of Excel, you can use combination of A$rand-var$ to go to a cell and get the value of the cell.

Hope that helps.

[forumsupport]

Hello,

For your convenience, we have attached a sample task. Please copy attached .atmn file under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. Copy .xls file under C:\.

Before running this task, please create a random list variable, RndVar. Please follow below mentioned steps to create random list variable,

1. Go to Tools->Variable Manager in Automation Anywhere.
2. Click on “Add New Variable”.
3. From "Type" dropdown, select 'Random'.
4. In “Name” field, enter “RndVar”.
5. Select 'Random Number - Range' option.
6. In “From” field enter value 1.
7. In "To" field enter value 56.
8. Press “Save”
9. Press “Ok”

This task would randomly fetch values from column A in a excel file and will paste the values in a Notepad.

Hope that helps.