Add column with Name and Value in each row

Help
, ,
1

Hi,
After I read range with headers and got dataTable, what’s the best way to add/append a column with header and same values dynamically for each row to this dataTable?
Thanks

2

you want to add values to same datatable without changing the header ?

1 Like
3

Yes, to this datatable which I’ve read. Just append the new column like:
Header
value1
value2
value3
…

4

use assign activity like this
yourDataTableVariable.Columns(0).ColumnName = “value1”
yourDataTableVariable.Columns(1).ColumnName = “value2”
yourDataTableVariable.Columns(2).ColumnName = “value3”
cheers @Slavich

1 Like
5

@Slavich
Use “AddDataColumn” activity - this will create a new column.
Then add values to it by using assign activity.

1 Like
6

I need firstly to add new column…

7

yes!
you can use data column activity! there itself you can change the column name!
if you want to change only the column name in the same datatable without changing the data in it you can use above syntax!

1 Like
8

You can add data column in Previous datatable using
Add Data Column
U can give Any name in properties
Then for assigning values in that columns Use For each row

1 Like
9

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