Greetings friends , Hope all of you are doing well. When I run a test, is

Greetings friends ,

Hope all of you are doing well.

When I run a test, is it possible for me to for me to take
each row from the data table , once at a time.

In other words,if i have 10 rows in the global data table,
say data1,data2, data 3...and so on up to data10.

Can I have the value of data1 when I run a test, and next
time when I run the same test (say next day), it should
skip data1 as it has already used it and go directly to
data 2 ???

Would be great if anybody can help me out know in this
issue.

Thanks & Regards !!

Question Posted / vikwin

4 Answers
5820 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Greetings friends , Hope all of you are doing well. When I run a test, is it possible for me ..

Answer / hemakumar.m

1)Answer
as per y knowledge there is no function to get entire row

2) Answer

U can maintain one colummn Ex:Status in excel sheet,when u
used particular data and u got expected result u palce some
text like useddata for used one and blank for unused data
(default) in u r excel sheet.u can write programme like
that when the status colummn value is used data skip that
step.

Is This Answer Correct ?

4 Yes

0 No

Greetings friends , Hope all of you are doing well. When I run a test, is it possible for me ..

Answer / vik

Thanks Mr.Hemakumar

Realy appreacite your time.

Actually, I need QTP to select a new user name each time
automatically. I want to pre-enter 50 names in the excel
data table and accordingly let QTP to take 1 value each
time.

So, if I can understand your answer right, there needs to
be a column named "Status". Assuming the first field
says "Raj", then QTP uses it because it has not been used
before.

However, next time with a new test how would you let QTP
know that it has already used "Raj". Have we got to
capture "Raj" as a already used data and then compare with
next test. If the value matches , then move to next field
to fetch the next field value. Am I right ?

Is This Answer Correct ?

3 Yes

1 No

Greetings friends , Hope all of you are doing well. When I run a test, is it possible for me ..

Answer / deepakm82

Hey Vik,
As far as i understand ur question,u saying that u have 50
users which use 50 different sets of data.
You have already pre-entered the 50 users and so u also
must have pre-entered the 50 rows of data used by 50 users.
What hemakumar is saying is that you can have a column
STATUS which gives you the position of the user.
Suppose 'Raj' is the first user and 'Vik' is the 2nd user
then STATUS would say 1 for 'Raj' and 2 for 'Vik'.
Now while running the QTP you can use following:
Datatable.SetCurrentRow("STATUS")
Depending upon the STATUS column the data row would b
selected.

Is This Answer Correct ?

1 Yes

0 No

Greetings friends , Hope all of you are doing well. When I run a test, is it possible for me ..

Answer / kashinath hajare

'Please Check Following code. In this code "Is_Required" is
defined in Datatable( Column Name). Make it as "1" or "0",
as per requirement. If value of this column "1", only that
column will execute.

iScenCount=DataTable.GetSheet("Global").GetRowCount

'Traverse throgh master datasheet to execute the scenario
For iRowCounter= 1 to iScenCount

DataTable.GetSheet("Global").SetCurrentRow iRowCounter

If trim(DataTable.Value("Is_Required", "Global")) Then

'Your Script code will be here
End if
Next

Is This Answer Correct ?

0 Yes

0 No

Post New Answer