How to insert a column in excel based on a certain column name

Help Robot
,
1

Say I have 3 column Last Week, Current Week and Change. I need to only insert a new column every time before column Change

Is that possible ?

Somewhat like this I need to achieve

Scenario 1 :

image

Scenario 2 :

image

3

Hi @Ishan_Shelke
dt.Columns(“columnname”).SetOrdinal(dt.Columns(“change”).Ordinal)

4

Where should I write/execute this code exactly ?

5

Read the excel as datatable and use assign statement to write this code and then write it in excel

6

Getting the below error :

image

7

Give column name inside double quotes and show me full assign activity

8

image
image947×270 16.7 KB

9

On left hand side change it to data

10

You can find that position of Change column and store it in Integer variable… Then use assign for Degreement (position_variable - 1) …

For ex,

Position_int=Datatable_variable.Columns.IndexOf(“Change”)

Position_int = position_int -1

Use Insert Column activity pass table name, column name as you want and then in properties, position you may pass that decrement varible(position_int)…