Dependent iteration between global and localsheet

[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