Datatables in QTP

Datatables:

A DataTable, similar to Microsoft Excel helps testers to create data driven test cases that can be used to run an Action multiple times. There are two types of Datatables.

• Local Data Table - Each action has its own private data table also known as local data table which is can also be accessed across actions.
• Global Data Table - Each test has one global data sheet that is accessible across actions.

The Data sheet can be accessed from the "Data" Tab of QTP as shown below:

To execute a test case for some specified number of iterations,one can set the iterations of global data table in the Test Settings dialog, that can be accessed using File -> Settings -> Run(Tab) as shown below:

Example:

For Instance, if user wants to parameterize "compound Interest" of "http://zubaerkhan.com/" that can be accessed using "http://zubaerkhan.com/compound-interest.php". The Parameters can be created as shown below. Most of the functionalities of Excel can be used in Data table as well.

Data Table Operations:

There are three types of objects to access Data Table. Data Table Operations can be well understood by traversing through the below link:

Object Type	Description
Data Table Methods	Gives Detailed information about the data table methods.
DTParameter Object Methods	Gives Detailed information about the DTParameter methods.
DTSheet Object Methods	Gives Detailed information about the DTSheet methods.