Associate a test value with a datapool column
Associate a value in a test with a datapool column
- Double-click a test
- Locate and click a request containing a value to replace with variable data.
![]()
If correlated data is not displayed, right-click the table and verify that Show References is selected.
![]()
Another good way to find datapool candiates is to use the Display Data Correlation window.
References are shown in blue letters, and datapool candidates are shown in black letters.
![]()
- Click the name of the datapool column to associate with the test value, and then click...
Substitute | Select Data Source
![]()
- Select a value to replace
![]()
- The Test Data panel shows substituion.
![]()
- Select test and then expand variables to see substitution values...
![]()
- Run test with a single user to verify datapool values are working correctly.
![]()
- After test finishes review test log for errors.
Notes
If the value to replace from a datapool is part of a string that has been designated a datapool candidate, remove the light green highlight: right-click and select Clear Reference.
For example, if you searched for doe, john in test, the datapool candidate in test is displayed as doe%2C+john. Suppose that you do not want to associate this candidate with a single datapool column containing data in the format doe, john. Instead, to associate doe and john with separate datapool columns. In this case, first remove the light green highlight.
![]()
To use a datapool that is not listed, click: Add Datapool
To indicate that the association has been set, the highlighting for the selected test value turns dark green, and the datapool table for this page is updated...
Encode variable data when it is substituted from a datapool
If a test value contains special characters such as spaces or commas, click the row and select URL Encode.
With this option, special characters are encoded when variable data is substituted from a datapool.
For example, data that is space-separated in a datapool column, such as...
John Doe
...is substituted as...
John%20Doe
If URL encoding is not selected, the variable data that is substituted is literal. Do not enable URL encoding for datapools containing data that is already encoded.
Related
Datapool overview How datapool options affect values that a virtual user retrieves Encrypted datapools overview Create a datapool associated with a test Create a datapool in the workspace Import a CSV file into a datapool Enable a test to use a datapool View datapool candidates when you open a test Edit a datapool Use a digital certificate store with a datapool Navigate between a datapool and a test