Interested to Buy Any Domain ? << Click Here >> for more details...
If i entered 2 columns and 4 rows inputs in DDT Like Mango
fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q
is How to get the 2nd column value for corresponding 1
column input in 3rd row ie, ( i need to get "veget" in
messge box @ run time
- 5 Answers
- 9441 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / satya
strCnt=DataTable.getRowsCount
For i=1 to strCnt
datatable.SetCurrentRow(i)
x=datatable.Value("A")
datatable("c")=x
Next
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ratna
datatable.setcurrentrow(3)
x=datatable.value(2,1)
'datatable.value(2,1) where 2 is column name and 1 is sheet
no. ie., 1 is for global sheet
msgbox x
'output is veget
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / saff
i= inputbox "enter ur string" # say brinjal
r=datatable.getrowcount #get row count
for i=1 to r #loop till the end of the row
datatable.setcurrentrow(i)
aa=datatable.(a ,dtglobalsheet) # column 1 value into aa
if instr(aa,i,1)=1 #compare the strings
bb=datatable(b,dtglobalsheet)
msgbox bb
exit
else
i=i+1
next
| Is This Answer Correct ? | 0 Yes | 1 No |
w is active screen
What is the entry criteria and exit criteria for your test automation
what and how to answer for the question "tell me about yourself ?" for 3 years experience. can anyone say inj detail please... its urgent
Explain script generated at the time of setting runtime property?
I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format, and also tell me the best institute and the estimate cost for joining the institute ib delhi NCR. Hence, if possible, kinldy mail PDF file to my mail-ID: kumar123.pathak@gmail.com , Regards, kumar pathak
What are the Test design techniques you uses in ur project?
anyone can explian about types of "Triggere Events" in QTP
Set DR= CreateObject("Mercury.DeviceReplay")
When using descriptive programming?
CAN WE USE 'BVA' AND 'ECP' IN AUTOMATION?
Can any one please explain hwo to test client/server application using QTP?
how do you do database testing in qtp
WinRunner 
