Answered question

You need to use Javascript logical action and code to parse your File used in the File Variable to get a line count. This line count value can then be used to run your loop count an exact number of times matching your values in the file.

Here is an example of the code you would use:

=====================
//Declare file with variable. Modify to match the path to your file variable.
var fileName = "C:\\Users\\NeoloadGuru\\Desktop\\Account.csv";

//Read File and get line count
var reader = new Packages.java.io.LineNumberReader(new Packages.java.io.FileReader(fileName));
while ((reader.readLine()) != null) {}
var lineCount = reader.getLineNumber();
reader.close();

//modify value by subtracting 1 from value if file variable has a column header line, otherwise don't use.
var lineCount = lineCount-1
//Log value of line count from file
logger.debug("Line number is = "+lineCount);

//Export variable with value of line count back to Neoload script.
context.variableManager.setValue("LoopCount",lineCount);

=====================

Now, this will parse the file to get a line count of values in the file. It can subtract 1 from the total to account for a column header, and export that line count value back to Neoload to use in the Loop Count.

Please refer to attached sample project for details.

LineCount.zip

LineCount.zip

16.2 KB

June 07, 2016

Processed