Problem with generated data table and keyword test

Question

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 CreateTestExecutionDataTable(){&nbsp; // Create a table variable if it doesn't exist&nbsp; if(!Project.Variables.VariableExists("TestExecDataTable"))&nbsp; &nbsp; Project.Variables.AddVariable("TestExecDataTable", "Table");&nbsp;&nbsp;&nbsp; // Get a reference to the variable&nbsp; var t = Project.Variables.VariableByName("TestExecDataTable");&nbsp;&nbsp;&nbsp; // Add columns to the table&nbsp; t.AddColumn("Test Execution");&nbsp; t.AddColumn("Environment");&nbsp; t.AddColumn("Build Type");&nbsp; t.AddColumn("Team");&nbsp;&nbsp;&nbsp; // Create rows TestExecutionData.testExecutionList.length-2&nbsp; t.RowCount = testExecutionList.length-2;&nbsp; Log.Message("Length of the execution table "+t.RowCount)&nbsp; for(let i = 0; i &lt; t.RowCount; i++){&nbsp; &nbsp; &nbsp; t.$set("Item","Test Execution", i, testExecutionList[i+2]);&nbsp; &nbsp; &nbsp; t.$set("Item","Environment", i, environmentList[i+2] );&nbsp; &nbsp; &nbsp; t.$set("Item","Build Type",i, buildTypeList[i+2] );&nbsp; &nbsp; &nbsp; t.$set("Item","Team", i, teamList[i+2]);&nbsp; }&nbsp;&nbsp;}Then I want to integrate a Data driven loop that will perform actions for each item in the table var.The problem occurs when I want to choose some values and perform actions, because I don't see anything.&nbsp;I don't have any idea about how to use this generated table in my keyword test.&nbsp;Does anyone have an idea?Thank you for your help.

hassan_ballan · Answer

Hello KevserSaruhan&nbsp;
Just a thought. Rather than using code, it would be simpler to permanently add the variable at the project level (right click on the project to select Edit &gt; Variables), then access it in the data loop. Edit Table Variable Dialog | TestComplete Documentation

&nbsp;

kevsersaruhan · Answer

Hello Hassan,&nbsp;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.&nbsp;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 · Answer

Hello KevserSaruhan&nbsp;
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&nbsp;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

scot1967 · Answer

Have you considered using an array instead?&nbsp; &nbsp;That is really all you are doing here.&nbsp;&nbsp;
function TestArray() {
  // Define an array
  var myArray = ["TestComplete", "SoapUI", "JavaScript", "VBScript"];

// Access array elements
  Log.Message("First Element: " + myArray[0]);

// Add an element
  myArray.push("Automation");

// Iterate through the array
  for (var i = 0; i &lt; myArray.length; i++) {
    Log.Message("Element " + i + ": " + myArray[i]);
  }

// Store the array in a project variable
  Project.Variables.MyJsArray = myArray;
}
&nbsp;

scot1967 · Answer

If you are using Excel these links explains how to directly open or create the Excel files to read and write contents.
https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/open.html
https://support.smartbear.com/testcomplete/docs/reference/program-objects/excel/index.html

Forum Discussion

Problem with generated data table and keyword test

Related Content

Problem generating project report via testrunner in Jenkins

Generating report

Generating a schema for a generic list in c#

Firefox buttons problem.

TestComplete command line problems

Recent Discussions

Handle embedded webview on Outlook

Stop testrun TestExecute/SessionCreator

How cant I define a param using in different testcase?

how can I invoke function between different project in one projectSuit?

Strange box around Indicator and TC application