how can I add a column to a data table but at a specific column index?
I.E
I want to add Column 4 into table
col1,col2,col3 but between col1 and col2?
1 Like
hi @Rowley101
first add data column to your dt
then filter data table activity and in output columns chose keep and write your order
1 Like
use add datacolumn activity
use write range activity and specify the range for eaxample you want add datacolumn at k position in range “k1”
And enable add headers
The SetOrdinal
method allows you to specify the index where the new column should be inserted.