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