-
Right-click the Global Random Variables tree menu node (Loaded Components pane, Objects tab) and select New Multi-Column Variable.
-
On the Multi Column Parameter Wizard, select a file that contains multi-column data. The files that are displayed in the combo box control are the CSV files that
are available in the Data directory.
-
When a CSV file uses a specific column separator, select the Separator so that .NET Explorer can accurately populate the grid displaying the contents of the file.
-
Specify a name for the Handle name variable. A file handle variable is a handle that is assigned a row in a multi-column file.
-
Select the column that should be bound to the new variable by clicking within one of the column’s cells. The currently selected
column is marked with an (*) at the end of the column name. Handle name and Parameter name are automatically generated when you change the file or select a different column if the user has not already changed the
name manually.
-
Specify a File name for the new bound variable.
-
Click Finish to open the CSV file in the registered client application (for example, Microsoft Excel). Changing the file in the client
application and re-selecting it in the combo box will reload the file with the revised content.
You will see the new file handle and the new column variable in the
Global Random Variables tree menu node. To bind another variable to another column in the file, right-click another file handle element in the tree
menu and select
New Multi-Column Variable. The wizard will reappear with read-only file properties (
File name,
Handle name, and
Separator).
These variables can now be used as input parameters for method calls. They will appear in the Input Parameter page variable list.