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

Help
14

Hi @VasuNaidu

I used this method and everything is working fine but expression also added in the formula column name which only “Formula” name supposed to display.

Concatenating 2 columns A and B and saving it in Formula but it appears Formula+A+B

How to make sure only the column name “Formula” appears

This is Target Object = dt.columns.add(“Formula”, GetType(String), “[A]+[B]”)

Passing 2 as in argument for SetOrdinal method