Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Multiple Data Set With Different Child Data Set
#1
Solved: 10 Years, 9 Months, 1 Week ago
Hi,

I am new with QTP and self learning this tool.

Need help while I am trying to visualize a process to setup a test with many reusable actions which will primarily receive paramitized data feed through datatable.

My dilemma is how to setup the process and it's data that can handle multiple data set, each having different child data set.

For Example: Hierarchy of an Auto Policy Insurance data will look as below:
Policy Deatils (Includes number & other Policy level Info.)
|
-->Vehicle Information (Includes each Vehicle level Info.)
|
--> All Coverages Information (Which could differ bewteen each Vehicles within the Policy)
|
--> Driver information (Includes all Drivers Info associated with each vehicle)

How can I setup the data and the process if I want to have a Single test with reusable actions such that the test can handle Multiple Policies with corresponding Vehicle, Coverages and Driver information?

Looking for your suggestions and thanks in advance.
Subha


Reply
#2
Solved: 10 Years, 9 Months, 1 Week ago
Suba,
You can columnize the excel to have action names and the rows to contain data respective to the actions.

Let me potray the logic,

1. Loop through the sheet to pick the values.
2. Create Reusable actions with Input and output action parameters.
3. feed the values from the datatable on to the input action parameters.

Your Test might look something similar to this,
Code:
For x=1 to totalrows
Runaction "ACtionName", Param1, Param2 etc
Runaction "ACtionName", Param1, Param2 etc
Runaction "ACtionName", Param1, Param2 etc
Next

Or you can perform the same on a case basis controlling the execution of the action.
Code:
Select(Case)
Case : ACtionDriver
Runaction "ACtionName", Param1, Param2 etc
Case: ACtionInsurance
Runaction "ACtionName", Param1, Param2 etc
End Select

It is very rustic at the moment. Please spend sometime to enhance it and if you face issues we can chisel in then.[/code]
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Reply
#3
Solved: 10 Years, 9 Months, 1 Week ago
Thanks Basanth. I will give a try.

Alternatively, using the looping mechanism, can I switch the datatable for each Policy data and it corresponding Vehile, coverages and drivers?

Thanks,
Subha
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Multiple rows of test data Bhuvana 0 1,154 01-03-2020, 09:30 PM
Last Post: Bhuvana
  Set data parameters Mik2s 1 1,281 03-07-2019, 10:18 PM
Last Post: supputuri
  Set Value in JavaEdit Inside JavaTable yonobev 9 11,788 11-08-2017, 11:12 PM
Last Post: lotos
  Excelsheet data entry Anshu 0 1,511 07-11-2017, 07:41 PM
Last Post: Anshu
  Want to read the data from excel and set read value in the JavaTable rajeevk7 0 2,172 07-10-2017, 04:20 PM
Last Post: rajeevk7

Forum Jump:


Users browsing this thread: 1 Guest(s)