How to concatenate two columns in datatable without looping and keep concatinated data in new column?

@Haroon_Patel - Pleas check this post…

thanks for that link but i need to add a space in between. How to do that?

dt1.Columns(“Name”).Expression = “[First Name] +”" “”+ [Last Name]"
Above gives error: Assign: Exception has been thrown by the target of an invocation.

@Haroon_Patel - syntax should be like this…

“[First Name] + ' ' + [Last Name]". I have tried this using invoke method and you can see the output AA 123…

Note: since my column name does not have spaces i didn’t included the square brackets

Ok will try it out with an assign activity first.
What Method did you use in the invoke?

Thanks a lot. I used it in assign and it worked.

@Haroon_Patel - Method Name is : SetOrdinal

and the Parameters