Forum Discussion

KevserSaruhan's avatar
KevserSaruhan
New Contributor
9 months ago
Solved

Problem with generated data table and keyword test

Dear Community, I have a problem with a created table type project variable. Here is my script, I checked data inside the generated table and everything is OK for the table. function CreateTestEx...
data-driven testing
KevserSaruhan's avatar
KevserSaruhan
New Contributor
9 months ago

Hello Hassan,

 

Thank you for your answer, I just want to keep this variable dynamic. These are informations provided by an Excell file. I also tried to do stores Excell file, test complete does not support my Excell version. I tried a lot of things. 

For this data driven loop I can maybe do as you said but after that I need another data driven loop that will use another table variable (in this one there will be data extracted from jira) So I need to do these process dynamically...

Hassan_Ballan's avatar
Hassan_Ballan
Icon for Champion Level 3 rankChampion Level 3
9 months ago

Hello KevserSaruhan 

Ideally you would use DB Table variable https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/reading-data-with-dbtable-variable.html However, the supported " Microsoft Office 12.0 Access Database Engine" is no longer available for download. Newer version also would not work. You may want to check with support for a solution.

You can still work with Excel to accomplish your goals https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/index.html 
1- create project persistent or temporary variables of Type "Table", and you can have as many as you need https://support.smartbear.com/testcomplete/docs/reference/program-objects/variables/index.html?sbsearch=variables During run time you can populate values.
2- read Excel cell
3- use "Set Variable Value" to save last operation result to the variable in step 1