Data table Iteration

[Shandru]

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

[KavitaPriyaCR]

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.

[Shandru]

Thanks for response kavita...
I will try by importing excel sheet...

[manishbhalshankar]

Hi Shandru,

Try this:

PHP Code:

For i = 1 To 3
   DataTable.GlobalSheet.SetCurrentRow(i)
   DataTable.GetParameter("ColumnName")
Next 


[bfakruddin]

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 Next

[Shandru]

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