Data tables

[kumarts]

Hi, Can some one give me an idea to resolve below issue.

I am trying to create a test that will create multiple orders with different Materials. I am able to create multiple orders but with only one material. I am using a data table within QTP and pulling the data to create the orders, but when I add another Material to the table it make it another line item in the order. I have tried SetCellData and GetCellData in QTP with no success.

[KavitaPriyaCR]

Hi You mean the result should be as:
----------------------
Orders Materials
----------------------
Order1 Material1
<BlankSpace> Material2

Order2 Material3
<BlankSpace> Material4
<BlankSpace> Material5
----------------------

If this is the case, then you should specify the cell as
'when pushing data to Datatable:

Code:

k=1
DataTable.GetSheet("SheetName").SetCurrentrow=k
DataTable("Orders","SheetName")=Order1
DataTable("Materials","SheetName")=Material1
k=k+1
'When pulling data from dataTable:
DataTable.GetSheet("SheetName").SetCurrentrow=k         ' specify required row here
getOrder=DataTable("Orders","SheetName")