Working With Data Tables During Parmetrization in QTP Testing

Quick Test enables you to insert and run steps that are driven by data stored in the data table. The data your test uses is stored in the design time data table, which is displayed in the data table pane at the bottom of the screen while you insert and edit steps. We can parametrize the test from the keyword view.


The data table has the characteristics of a Microsoft Excel spreadsheet, meaning that you can store and use data in its cell and you can also execute mathematical formulas within the cells. Select the parameter from the Value Configuration option dialog box.


Working with Global and Action Sheets

When working with tests, the data table has two types of data sheets, Global and Action. You can access the various sheets by clicking the appropriate tabs below the Data Table.

You store data in the Global tab when you want it to be available to all actions in your test and you want the data to control the number of test iterations.
You store data in the actions tab when you want to use the data in data table parameters for that action only and you want the data to control the number of action iterations.


Global Sheet

The Global sheet contains the data that replaces parameters in each iteration of the test. If you create a Global parameter called Arrivals, the Global sheet might look like this:


Action Sheet

Each time you add a new action to the test a new action sheet is added to the data table. Action sheets are automatically labeled with  the exact name of the corresponding action. The data contained in an action sheet is relevant for Data Table parameters in the corresponding action only.