Add a new column

Help Studio
1

hi,
how do I add a new column to a table?

image
image1158×336 12.3 KB

2

I believe there is an insert column activity for excel

3

@dvojinovic

Try these steps:

  1. use Read range activity to read Excel file and save ouptut in variable DT_Excel with type datatable.

  2. use Add data Column activity and pass the column name which you want to enter and pass same Datatable variable in it. You can also give Any default value to rows in that column.

Hope this will works for you.

4

Hi @dvojinovic

You can use the ‘Add Data Column’ activity for this.

image

Hope this helps,
Best Regards.

5

Hi @dvojinovic

You can use the Insert column activity to add the column in the excel. Check the below image for more clarification.
image

Hope it helps!!