Forum Discussion
I have the countries in one spreadsheet and the inputs and verification data in separate spreadsheets. The reason for this is that countries A, B and C have the same input values while C, D, E have a different set of inputs and so on. So depending on the country I just want to point the keyword test to the desired spreadsheet but I am not a programmer so right now I am limited to using what I can find in the keyword prepackaged commands and wizards.
In sort term you can get duplicated test, one for country A ,B, C and other one for D,E,F ...so on.
But your scenario can be covered by single test with little bit of additional logic+programming.
You can not open two (or rather nested ) DDT loops at a given time.
Automated testing involves programming essentially. even keyword tests uses basic programming logic. If you are going to stay with automated testing learn some basic programming concept any try hands on with TC. Good thing is no need to be a full stack developer. Can start with simple basics and progress on.
- tristaanogre8 years agoEsteemed Contributor
Rather than using the built in Data Driven Loop operation of Keyword Tests, try using the "Call Object Method" operation. For the object, select DDT from the list. And then select the ExcelDriver method. You can then pass your spreadsheet name in to the method as a variable in the appropriate parameter and use DDT.CurrentDriver to then utilize the driver object in a while loop to build your DDT loop.