Writing to datatable- writing the rows in a single line

[Malathy]

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

[sreekanth chilam]

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