Create a variable

The Variables dialog is accessible:

with the Edit > Variables command
with a click on the Variables toolbar button.

To create a variable, click the New Variable button.

NL-CreateVariables-6.3

Then select the type of variable you want to create:

Counter: A numerical variable having an initial value, a maximum value and an incremental value.
List: A list or table of values. Use ${<variable Name>.<columnName>}. For example: ${ListVariable0.col0}

Tip: A click on the column header makes it possible to rename the column. For example, ${accounts.login} can be used instead of the default name ${accounts.col_0}.
Data sets can be imported with a click on the Import data button. For more information, see Datasets.

File: A list or table of values loaded from a text file. Use ${<variable Name>.<columnName>}. For example: ${ListVariable0.col0}. The first line of the file can be used as columns headers name.
The file variable only works with CSV (Comma Separated Values) format files.

SQL: A list of values loaded from a database request. The SQL variable executes a request to the database and stores the values in a temporary CSV file. The temporary CSV file is placed in the project directory SqlTemp subdirectory. The content of the file is updated each time the scenario is launched.
Two configurations are possible depending on the database driver selected:
1. Guided mode:
  The MySQL, Oracle, DB2, PostgreSQL or Microsoft SQL driver must be selected. In this mode, the following fields must be filled in: host, port, name, user name and password for the database. The MySQL, Oracle and PostgreSQL drivers are available by default. Please check the supported versions of each driver under the Database section of the Monitors documentation. Use manual mode for unavailable drivers.
2. Manual mode:
  The Custom driver must be selected. In this instance, the JDBC driver (Java DataBase Connectivity) usually takes the form of a file bearing the .jar extension. This file must be installed in the /lib/jdbcDrivers under the root NeoLoad installation directory.
  
  If you want to request a MySQL database with a version lower than 5.6, here is a example:
  
  mysql-connector-java-5.0.4-bin.jar
  
  The Driver name is unique to the driver used.
  For example: com.jdbc.mysql.Driver for mysql.
  
  The complete URL is used to specify the access path to the database. This URL must include at least the following information: host name, port, name, user name and password for the database.
  For example: jdbc:mysql://localhost:3306/test?user=neotys&password=secret
Only SELECT type requests are authorized within the SQL request. For example: SELECT * FROM users

The Test button allows checking the validity of the database connection information and SQL request.

The test window shows the following items:
- Query contains the SQL request.
- Results: Request results preview pane.
- Error details: This field shows the errors returned by the database driver.
Random Integer: A random numerical value within a value range.
- Predictable randomization: When this option is selected, randomly generated values will have comparable values for two identical tests.
Random String: A random alphanumerical string defined within a value range.
- Predictable randomization: When this option is selected, randomly generated values have comparable values for two identical tests.
Constant String: A string which value cannot be modified.
Password: An alphanumerical string whose value is encrypted on the hard drive and hidden.
Date: A date in the desired format. May be incremented.
CurrentDate: The current date in the desired format.
Random UUID: Universal unique identifier in the XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX format. Can be generated in lower case (default) or upper case.
- Predictable randomization: When this option is selected, randomly generated values have comparable values for two identical tests.
Shared queue: A queue that allows sharing dynamic content between Virtual Users. For more information, see Shared queues.
JSVariable: A variable computed by a Javascript. The script must contain a function named evaluate that returns the variable value.
For example:
```
function evaluate() {
```
```
    return new function() {
```
```
            this.firstField = "a value";
```
```
            this.secondField = myLibraryFunction();
```
```
    }
```
```
}
```
Variable field values can be accessed by using either the syntax ${<variable name>.col_<field number>} or ${<variable name>.<field name>}
For example: ${JSVariable0.col0} or ${JSVariable_0.firstField}

The NeoLoad API and the JavaScript library in the script definition of the variable can be used. For more information, see API overview, and JavaScript libraries.

EN_designvariablescreate

Starting from line

You can choose at what line to start using your File and List-type variables.

Enter the line number in the Starting from line field.

Information: When "Starting from line" is used with the option "Cycle values", values are starting from the line configured only in the first cycle.

Datasets

File and List-type variables may be populated using predefined datasets.

Datasets are organized by themes and countries: zip codes, family names, country names, street names, female first names, male first names, and street types.

Information: Only one theme may be used for a given variable.

Value change policy

All variables (except CurrentDate) may define a value change policy. This is sometimes referred to as a variable lifetime.

Each use: The value is systematically changed upon each use.
Each request:The value is changed each time a new HTTP/HTTPS request is played, the variable retaining the same value in both the request and the response to the frame.
Each page: The value is changed each time a new page is played, the variable retaining the same value for all the requests defined in the page.
Each iteration: The value is changed when switching between Containers Init - Actions - End and for each iteration of the Actions Container, the variable keeping the same value for all the pages and requests within a same iteration.
Each Virtual User instance: The variable retains the same value for all pages and requests of a given Virtual User instance.

Value distribution policy

A variable value distribution has three available settings:

Scope: The value scope can be:
- Local: The values are specific to each Virtual User.
- Global: The values are shared among Virtual Users.
- Unique: Identical to Global, with the guarantee that a value is only used by a single Virtual User at a time.
Order: Values may be distributed in a set order:
- Sequential: Values are taken in the order they are defined.
- Random: Values are taken in random order.
- Any: Best effort sequential order. This order is more efficient than sequential order.
When no values are left: Several policies can be applied:
- Cycle: The values are used over again, starting from the top.
- Stop test: The load test run is stopped when all the variable values have been used.
- Return the value "<NO VALUE>": All subsequent requests for values return this value.