+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Data table Iteration (/Thread-Data-table-Iteration)
Data table Iteration - Shandru - 11-24-2010
Hi Friends,
In data table i want column # 1 should repeat one time and column # 2 should repeat 3 times,the Column # 2 will always call the action function for each step..
please any body give solutions for this..
By
Shandru
RE: Data table Iteration - KavitaPriyaCR - 11-25-2010
Hi
As per my knowledge, there is an option to iterate the scripts row wise in Settings tab. If any one knows this can be done column wise, please let us know.
But Shandru, this can be achieved by using the excel file instead of datatable.
RE: Data table Iteration - Shandru - 11-26-2010
Thanks for response kavita...
I will try by importing excel sheet...
RE: Data table Iteration - manishbhalshankar - 11-30-2010
Hi Shandru,
Try this:
PHP Code:
For i = 1 To 3
DataTable.GlobalSheet.SetCurrentRow(i)
DataTable.GetParameter("ColumnName")
Next
RE: Data table Iteration - bfakruddin - 11-30-2010
Hi Shandru,
First thing, The iterations will be done based on rows not on columns...
we can do iterations based on columns also, but need more programming. for your case I developed small piece of code, check it once and revert me if you need additional info,
This type of questions will be get in Interviews not in real time. we've many work arounds to solve these situations.
Code:
' Iterations based on Columns in Datatable
' First column will run once and second column runs thrice calling the Actions/Functions in it for every iteration.
Dim RC, CC, i, j, var
RC = Datatable.GetRowCount
CC = Datatable.GetSheet(dtGlobalSheet).getparametercount
print "Row count of the Datatable is :"&RC
print "Column Count of the Datatable is :"&CC
Function One()
print "First Function is executed"
End Function
Function Two()
print "Second Function is Executed"
End Function
Function Three()
print "Third Function is Executed"
End Function
For i=1 to CC
For j=1 to RC
If (i=1) Then
print i&"st Column iteration"
print j&" Row cell value of "&i&" Column is :"& Datatable.Value(i,dtGlobalSheet)
Datatable.SetNextRow
End If
If (i=2) Then
For des = 1 to 3
For k=1 to RC
var=datatable.Value(i,dtGlobalSheet)
'print "The Function Name is :"&var
Execute Cstr(var) 'or 'Call Cstr(var)
Datatable.SetNextRow
Next
Next
Exit For
End If
Next
if(i=2) Then
Exit For
End If
NextRE: Data table Iteration - Shandru - 12-02-2010
hi bfakruddin
Thxs for detailed responce...i tried your code by modifying some variable changes now its working fine ..once again thx a lot
regards,
Shandru