i have an excel, For e.,g Column1,Column2 ABC,23 CBD,45 HDR,78 I need to insert a column in the above dt and the coulmn shold have value as “Yes”. I need to achieve this without using for each as for-each loop takes more time. The result should be like this. Column1,Column2,Column3 ABC,23,Y…

Hi @Manikandasamy , Have you tried the Activity Add Data Column ? It has a property called Default Value which you could use it to update all values of that column to the specified value.

DATTABLE / EXCEL Add column with value

Help Studio

balupad14 (Balamurugan (BalaReva)) December 21, 2022, 11:09am 4

Hi @supermanPunch ,

Here is a simple sample for you.

DatatableAddColumn.zip (72.9 KB)

Regards
Balamurugna.S

Topic		Replies	Views
Add a new column Studio uiautomation	4	400	July 6, 2023
Add New column to excel in uipath Studio studio , question , activities_panel	4	637	November 12, 2023
Add a new value to a data table column Studio studio , question , activities_panel	6	782	September 25, 2023
How to Add data column with values Activities excel , activities , question	15	14863	December 13, 2022
I want to add new column to a table with default value based on another columns Studio studio , question , activities_panel	2	1134	November 24, 2022

DATTABLE / EXCEL Add column with value

Related topics