Two concadinate two columns values datatable without looping

[AshwinS2 (Ashwin S)]

Hi @brindhaS

Check this

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

Here is the solution: Use Invoke method activity, assume my DT column names are ‘Entity’ and ‘AccountId’. TargetObject: DT.Columns.Add(“FORMULA”, GetType(String), “[Entity]+[AccountId]”) MethodName: SetOrdinal (Need to pass the ordinal value using argument) Where FORMULA- my new column name(Concatenated columns) SetOrdinal- new column ordinal position

Thanks
Ashwin S