Action end datatable row changes.
I've tried everything I can think of and searched on here. Apologies if this is something fundamental. I just can't understand why it's happening. I have two rows of data in an Excel spreadsheet which I import into the Action1 datatable. After the second row of data is input during the Create New Customer action and returns to Action 1 the data row moves from row 2 to row 1. Which obviously causes me an issue later on. I am baffled.
Run one iteration only.
DataTable.ImportSheet vDatasheet,"input" ,"Action1"
Dim rowCount, i
'Login to the application
RunAction "Login", oneIteration
'Navigates to the new customer screen
RunAction "Navigate To New Customer", oneIteration
For i=1 to rowCount
'Inputs new customer details
RunAction "Create New Customer", oneIteration
Dim vOutput, vTestCaseID
'Captures new customer number
vOutput = CaptureCustNo
vTestCaseID = DataTable.Value("test_case_id", dtLocalSheet)
'builds array of output and test case ID
aOutput(i-1) = vOutput'DataTable("Class","ShtName")
aTestCaseID(i-1) = vTestCaseID
Re: Action end datatable row changes.
Fixed it. D'oh. Using the Global datatable instead of the Action1 datatable solved the issue but I guess you probably already knew that.