How to add the row data on specific column in Existing data table?

Help
1

Hii Guys ,
Please try to help me on this.

Existing data table like this:

part number Issue id 1 Issue id 2 Issue id 3 Issue id 4 Issue id 5 Issue id 6 Issue id 7 Ageing created by
A 1 2 ranjith
B 11 12 13 ram
C 21 22 23 24 sunil
D 31 32 33 34 35 sahoo
E 41 42 43 44 45 aravid
F 51 52 53 54 55 56 manju

i need to add the data in Ageing column
ageing column data like this.

Ageing
6
5
5
3
9999
77

I want output like this.

part number Issue id 1 Issue id 2 Issue id 3 Issue id 4 Issue id 5 Issue id 6 Issue id 7 Ageing created by
A 1 2 6 ranjith
B 11 12 13 5 ram
C 21 22 23 24 5 sunil
D 31 32 33 34 35 3 sahoo
E 41 42 43 44 45 9999 aravid
F 51 52 53 54 55 56 77 manju
2

@Ranjith1996 Create datatable with one column using build datatable activity and add these values to that datatable, after that write that datatable using write range activity with starting range as Column Alphabet and 2 (Ex;A2,B2,C2)

3

is it possible to add that column by using add data row activity

4

@Ranjith1996 yes you can do it, but u have to add one element at each time using add row activity.

5
  • Remove the old column using remove data column activity.
  • Add “ageing” column using add datacolumn activity with data.

Or you can also try the below one.

  • Assign Datatable1.columns(“ageing”) = datacolumn1