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

[aebrahim.eg (Aebrahim)]

I have a table called table1 as shown below

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

[Yoichi]

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,