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

[msan (Michel SAN)]

Hi,

Actually, the DataColumn’s ColumnName or Caption are not changed but the write range activity seems to rely on DataColumn’s ToString method to ouput its header and this will take first the DataColumn’s Expression property if defined.

If you use the Output Data Table you’ll see different headers.

Use Log Message with the following, you’ll see:

DT.Columns(“Formula”).ToString
DT.Columns(“Formula”).Caption
DT.Columns(“Formula”).ColumnName

I don’t know if you can override the DataColumn’s ToString method in VB as a workaround. You might have to handle your headers by your own means.

I’m asking for a change in the post below: you should “vote” if this matter to you.

Keep Write Range headers consistent when defining DataColumn.Expression

Hi, When you use UiPath.Excel.Activities.WriteRange activity with AddHeaders checked, the headers are not those in OutputDataTable produced string when you set a DataColumn.Expression propertie. Could you please make the headers produced by WriteRange the same are those produced by OutputDataTable? If I had to chose, I’ll pick DataColumn.Caption property as header. You’ll find an example as attachment. You’ll need UiPath.Excel.Activities to run it. WriteRangeHeader.xaml (7.7 KB) Here is a p…