Automation Anywhere - The Automation Software

Automate Testing -> T10- Automated Test Data Generator

Task Description: To test your application, you often need large random data created in database. This example demonstrates how to use random variables to generate test data for testing. See more Automated Testing examples

Solution
1.	Record a new task.	Record a task that enters a value in one of the columns in your database for e.g. Microsoft Access
2.	Create a random variable.	Create a random variable using the Tools->Variable Manager. Screenshot 1 You can generate two types of random values in Automation Anywhere String - Specify the length of random string you want to generate Numbers - Specify the lower and upper range between which you want to generate random numbers. For e.g. to generate random numbers between 4 and 10 you would specify 4 in From and 10 in To.
3.	Populate seed data in multiple columns	Open the recorded task in Editor and put a loop of 100 around the keystroke action that enters the value in your database. Replace the recorded keystroke action with a random variable as shown in Screenshot 2

When you run this task, it will enter 100 random values in your table. You can change 100 to any other number and enter thousands of rows for testing purposes and save time creating those records in your database.