I want to concat two values from a data table and add these as one value into a third column/cell (same Data Table).
First I extend the data table with “add Data Column” activity (“newColumn”).
- The I use a for-each loop trough the data table and create a “concat_var”.
- I assign this concat_var to dt.Rows(currentRowIndex)(“newColumn”)
And this is what I get when write range to Excel:
Can sombody tell me what I am doing wrong?