How to add. New column in datatable and write a name

Help
, , ,
1

Hello,

I have data table named as DT. I want to add a name in the last column of the datatable and need to write a specific name as per DT rows. For an example if DT rows has 100 row i need to write a name as “Excel” 100 times in last column of the DT table.

2

You can use the build datatable or add data column activity.

3

For add a column to an existing datatable you need to use the activity “Add Data Column” :slight_smile:

4

I tried this method it is not working

5

Thank you. How can i insert a name as per row count. In the added column.

6

Use inside for each row one assign activity, and assign the row index of the added column(ex: row(0)) or use the column name(ex: row(“Type”)) and put the name you want.

1 Like
7

I got your point but I would like to know how you want that to be in excel file
Can I have a sample if possible with a image or screenshot
Cheers @jais1609