How to overcome the limitations of Add Data Row

[Pravin_Mandadi]

Hello Everyone…

I have to write data into 37 columns… So I used Add data row activity to write the data into a datatable. But the activity is allowing only 16 columns. If I add 17th column value in add data row activity it is throwing an error called ‘too many arguments’

Can any one help me…

Thanks in advance.

Regards,
Pravin.

[Anil_G (Anil Gorthi)]

@Pravin_Mandadi

Try using add /append to collection and append all the values and pass the array variable instead…that should solve it

Or use assign to create array and then assign the variable in add data row

Cheers

[Priyanka_Ramesh]

Hi ,

I tried with 20 columns but didn’t get any error . Please check if your build Datatable and Add data row columns match.

[Pravin_Mandadi]

try to input variables in add data row more than 16.

If I give more than 16 variables as input to add data row activity it is throwing error.

[Pravin_Mandadi]

It is working for 16 variables as shown above…

It is throwing error for 17 variables as shown above

[Priyanka_Ramesh]

Hi ,

Build datatable :

Add data row:

Excel output :

[Pravin_Mandadi]

instead of giving a,b,c,d values, try to give variables and check

Regards,
Pravin.

[Anil_G (Anil Gorthi)]

@Pravin_Mandadi

Did you try doing it the above way provided?

Cheers

[Priyanka_Ramesh]

Hi ,
Add the Data to the List and then Join the list to string and use it in Add Data row.