Dependent iteration between global and localsheet

[zingcrazy]

Hi,
I want to control localsheet iteration based upon globalsheet.

e.g.-I have 3 worksheets in an excel file-
1)globalsheet
2)local1
3)local2

the 1st row in all the 3 sheets contain testcase ids.


I want to run the script so that it will pick the 1st value from the globalsheet ,will move to the next worksheet,pick the corresponding values from all the columns for which the row no is 1 and then move to the next worksheet and do the same.

The worksheet is individual for each action which is based on individual page according to the application.

Please take a look into the attached excel file.(rename the file to ".xlsx" since i am not allowed to upload an excel file
  New Microsoft Office Excel Worksheet (2).txt (Size: 13.5 KB / Downloads: 132) )

[kordirko]

Hi,
the script might look like this:

Code:

For i = 1 To DataTable.GlobalSheet.GetRowCount
        
        globalTCID = DataTable.GlobalSheet.GetParameter("TCID").ValueByRow( i )

        For j = 1 To DataTable.GetSheet("Local1").GetRowCount
               If DataTable.GetSheet("Local1").GetParameter("TCID").ValueByRow( j )  = globalTCID Then
                     ' do the test for data in row nbr 'j'
                     MsgBox( globalTCID & " -- Last name  -----> " & DataTable.GetSheet("Local1").GetParameter("Last_Name").ValueByRow( j ) )
               End If
        Next

        For j = 1 To DataTable.GetSheet("Local2").GetRowCount
               If DataTable.GetSheet("Local2").GetParameter("TCID").ValueByRow( j )  = globalTCID Then
                     ' do the test for data in row nbr 'j'
                     MsgBox( globalTCID & "-- VIN  -----> " & DataTable.GetSheet("Local2").GetParameter("VIN").ValueByRow( j ) )
               End If
        Next
Next

[nilanjans]

Hi,

I downloaded your file but in my system as i don't have MS Office so not able to see the actual content. Open office is not able to recover this file.

But from the question what i understand, you are trying to run all local action rows for every Global datatable row.
Means Global datatable Row 1--Local action rows( say 1-3) will run and then it will move to next local action 2 and run all rows( say again 1-3) over there. Then when all action gets completed the the same will happen for Global datatable Row 2.And this will continue how many rows the global datatable have.
Please clarify me if i have any wrong understanding.

You can handle this situation by using the Global Iteration property from File-->Settings.( You need to make it "Run for all Rows", which is by default selected).
and for all the local actions those you want to run for all rows go to their "Call properties dialog" and in Run tab select "Run for all Rows", which is not the default case).

I think by doing this only you can meet the expectation.

Anyone please differ please let me know your view.

Thanks,
Nilanjan