Concat multiple column data into another column through linq

Help Forum
4

assuming your datatable variable is called dt
a. use add data column activity to add data column called Col6 (if it doesnt exist)
b. use invoke code
click edit arguments and add in/out argument dt

image
image735×449 13 KB

then click edit code and paste this

dt.AsEnumerable().ToList().ForEach(Sub(row) row("Col6")= row("Col1").ToString+row("Col2").ToString+row("Col4").ToString+row("Col5").ToString)

this will set Col6 = col1+col2+col4+col5