Writing to datatable- writing the rows in a single line

Writing to datatable- writing the rows in a single line - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Writing to datatable- writing the rows in a single line (/Thread-Writing-to-datatable-writing-the-rows-in-a-single-line)

Writing to datatable- writing the rows in a single line - Malathy - 05-17-2011

Writing the output from the application . Need to write the output under 3 column names DDA , Bank ID and Available Balance in the datatable(Bal_DDA).

Code:

Code:
n=DataTable.GetSheet ("Bal_DDA").AddParameter("DDA",DDA) 

o=DataTable.GetSheet ("Bal_DDA").AddParameter("BanklD",BankID)

m=DataTable.Getsheet ("Bal_DDA").AddParameter ("Avail_Bal",Avail_bal)

Actual Output :
DDA BanklD Avail_Bal DDA1 BanklD1 Avail_Bal1
44357 182 300 41210 182 0
Expected Output:
DDA BanklD Avail_Bal
44357 182 300
41210 182 0

RE: Writing to datatable- writing the rows in a single line - sreekanth chilam - 05-17-2011

Hi Malathy,

Refer the below example as per your requirement.

Code:
DataTable.GetSheet ("Bal_DDA").AddParameter "DDA","" 

DataTable.GetSheet ("Bal_DDA").AddParameter "BanklD",""

DataTable.Getsheet ("Bal_DDA").AddParameter  "Avail_Bal",""

Datatable("DDA","Bal_DDA")=44357

Datatable("BanklD","Bal_DDA")=182

Datatable("Avail_Bal","Bal_DDA")=300

Datatable.GetSheet("Bal_DDA").SetCurrentRow(2)

Datatable("DDA","Bal_DDA")=41210

Datatable("BanklD","Bal_DDA")=182

Datatable("Avail_Bal","Bal_DDA")=0

Tip: it is better to maintain the test data in Datatable and use/pass the data from Datatable.
If you do so then we can make use of available Datatable Methods efficiently Smile