How to append range

Help Studio
7

Hi

To take it very simple
Let’s add the number of columns we want with the help of ADD DATA COLUMN a activity and if we want to change the name of the column then a assign activity with this expression would help you resolve that

dt.Columns(“yourcolumnname”).ColumnName = “new column name”

And you can use APPEND RANGE activity

In order to sort the columns, Use Filter Datatable Activity, And in Output Columns Section, Assign the Column Names in the Order you need it.

To include a column in any position of a datatable

Hope this would help you

Cheers @andreus91

1 Like