How to Control the Number of Rows Used - Test Data Settings

When attaching test data, by default, the number of rows in the CSV file determines the number of test runs. A test can have multiple CSV files attached that contain different numbers of rows of test data. In this case, you determine the number of rows from all applicable files that will be used, skipped, or looped, respectively.

 

To control how many rows of test data are used:

  1. Open a GUI Functional or Performance Test with CSV files attached.
  2. Click Test Data, then click Iterations (for GUI Functional Tests) or Data Settings (for Performance Tests) respectively.
  3. In the Test Data Settings window, choose one of these Run Options:
    • Defined Number of Rows
      Specify a number between 1 and 1000000. The test will run with test data from this number of rows, from all files. Extra rows from longer files will be skipped, rows from shorter files will be used repeatedly.

    • All Rows From This CSV or F&R Model
      Select an attached CSV file or Find&Reserve model. The test will run with test data from all rows of this file or model. Extra rows from other files or models will be skipped, rows from shorter files or models will be used repeatedly.

    • All Rows From Longest CSV or F&R Model, Loop Others
      The test will run with test data from all rows of the longest attached file or model. Rows from shorter files or models are used repeatedly.

    • All Rows From Shortest CSV or F&R Model, Do Not Loop
      The test will run with test data from all rows of the shortest file or model. Additional rows from longer files or models are skipped.

  4. In the Test Data Settings window, choose one of these Target Options:

    • Delimiter — Indicates the column delimiter that your configuration files use for CSV data, for example "\t" for the tab character. The default delimiter is a comma.
    • Ignore First Line — If set to true, BlazeMeter treats the first row of data as column headers (which will become Data Parameter names). Set it to false if the first row contains data.
    • Allow Quoted Data — If your column values can contain commas, and you also use commas as delimiters, then set this to true.
      Example: If a cell value can be "123 Main street, Springfield", then allow the integration to surround the data with double quotes, otherwise the column will be missegmented into two columns.
    If Target Options are read-only, they have been loaded from the test configuration and are displayed for your reference. To edit these options, edit the test configuration file.
  5. Click Save.

 

Test Data Settings Examples

File A File B Option selected Outcome Iterations
5 rows 100 rows Run 1 row
(default)		 Use the first row from file A.
Use the first row from file B.		 1
10 rows 100 rows Run 5 rows Use the first 5 rows from file A.
Use the first 5 rows from file B.		 5
5 rows 100 rows Run 10 rows Loop twice over the 5 rows from file A.
Use the first 10 rows from file B.		 10
5 rows 100 rows Run all rows from file B Loop 20 times over the 5 rows from file A.
Use all 100 rows from file B.		 100
20 rows 100 rows Run all rows from longest file, loop others Loop 5 times over the 20 rows from file A.
Use all 100 rows from file B.		 100
20 rows 100 rows Run all rows from shortest file, don't loop Use 20 rows from file A.
Use the first 20 rows from file B.		 20