I wanted to iterate through different columns for fixed set of rows. Scenario is like :
Objects Input ExpectedOutput Input ExpectedOutput Input ExpectedOutput
obj1 1 1 1
obj2 1 1 1
obj3 1 1 1
obj4 1 1 1
obj5 1 1 1
obj6 1 6 2 7 3 8
[Attaching Datatable for your reference]
As can be seen, data table is configured in such a way tat for one set of "Input", I will be getting specific "ExpectedOutput" on UI eg: 6 for the first iteration.
With same set of objects and differnt "Input" values - I will be getting another "ExpectedOutput" on UI eg: 7 for the second iteration and so on.
Thus, rows will remain constant throughout and I wanted to just navigate through different columns to get the inputs. How can this be achieved?
I have tried below code and its working fine for first iteration but second iteration is again taking same values as in case of first iteration:
For j=2 To ColCnt
For i = 1 to RowCnt
'strInput=DataTable.GetSheet(TemplateID).GetParame ter("Input") ' This is another approach I tried
j=j+1 ' This is to skip ExpectedOutput column for next iteration
<font class="small">Code:</font><hr /><pre>ParamCount = DataTable.LocalSheet.GetParameterCount
RowCount = DataTable.LocalSheet.GetRowCount
For j= 1 to RowCount
For i = 1 To ParamCount
Print DataTable.GetSheet(dtLocalSheet).GetParameter(i).V alueByRow(j)
Next </pre><hr />