Forum Discussion
Hi,
Maybe I missed something in your question... but just go through all fields on web page that are subject to get data from Excel file and check if their value corresponds to the one from Excel.
The problem is if I have 70 records, each with say 15 columns, how do I loop through each field in the web page and the compare to the field(s) in the DB, especially if the rows in the web page could be in different order. I had use checkpoints but I do not see a way to read data from an excel worksheet and use that as the checkpoint data to compare. Sorry if I am making this confusing. I am not looking to click on each field in each row, for 70 plus records and set a checkpoint. I would like to be able to read in the data from Excel and then have the tool search the Web page to make sure that data exists in the correct field for the correct row. I do have a key that I maybe able to use to do the initial search, say a order # and then would want to go to each field in that record and compare to that same record in the web page. Hopefully that makes sense.
- Marsha_R2 years agoModerator
Give us an example with 2-3 rows of data and screenshots of your web page with the data loaded and we can try to give you a more specific answer.
Related Content
- 3 years ago
- 6 years ago
- 4 years ago
Recent Discussions
- 10 hours ago