I am trying to populate a list of Neoload variables from a single SQL query. Is there a way of doing this in Neoload?
If I have a query like "SELECT firstname, lastname, age, gender FROM users;" when I execute the query I retrieve one row of values such as "john,doe,49,male" and I want to use this to set the value in the respective neoload variables.
You can use a SQL Variable, they are multi-valued.
Once the Query is defined for the variable "Users", then you can access the different columns with ${Users.firstname}, ${Users.lastname}, ${Users.age}...
Did you find this useful ?
100% of users found this answer useful
christophe was made best respondent
christophe answered
Dean posted a new question
