How to add data in columns in datatable

Help Studio
, ,
1

Hi Team,

I need to add data in columns in a Datatable.
Datatable has columns in which column A and B is filled with data and I need to fill the data in empty column C , D , E.

I am using for each row activity and adding data in column C,D,E using add data row activity. But it is not working as I am getting the error

2

@Karan28

In Datatable you have column names as A & B ? can you be clear with that?

Are you refering to Datatable or Excel column name?

Thanks

3

it looks like you want to fill data to the cols C;D;E of a row which is present with filled A,B

Give a try on:

For each row Acitvity: row -YourDataTableVar

  • Assign Acitvity: row(C) = “Your CValue”
  • Assign Acitvity: row(D) = “Your DValue”
  • Assign Acitvity: row(E) = “Your EValue”
4

In the “ForEachRow” Activity use a assign activity and assign as below
CurrentRow(“C”) = DesiredValue
CurrentRow(“D”)=DesiredValue
CurrentRow(“E”) = DesiredValue

5

How to fill the data in a loop , do I use a add data row activity?

Because I am using the same in a loop but getting the error :- {
“message”: "For Each Row: Collection was modified; enumeration operation might not

6

Please find the sc
Capture22
CaptureTo
reenshot

7

@Karan28

For filling the data to other columns you can check below for your reference

Hope this may help you

Thanks

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.