I want to add new column to a table with default value based on another columns

I have a table called table1 as shown below
image
I would like to use the “Add data column” activity to add a new column whose default value should be “PO_”+ Column2 value.
I would like to achieve that using the Default value option of the “Add data column” activity and without for loop.

Thanks in advance

Hi,

Can you try the following step?

First add DataColumn as String type using AddDataColumn activity. (Let’s say “newColumn”)

Then use the following expression in Assign

dt.Columns("newColumn").Expression =  "'PO_'+Column2"

Regards,