Add a new column

how do I add a new column to a table?

I believe there is an insert column activity for excel


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.

Hi @dvojinovic

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


Hope this helps,
Best Regards.

Hi @dvojinovic

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

Hope it helps!!