@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.