How can add Column After Or Before Specific Column

[anh.nguyen]

I want to add Col before another Col. I use Invoke Method, but don’t know use Parameters ?. Please help me

DT_Input.Columns(“AddCol”).SetOrdinal(DT_Input.Columns(“AddCol2”).Ordinal)

[Jithesh_R (Jithesh Karkera)]

@anh.nguyen ,
Please refer this thread this might help you.

Add Column and make it as the FIrst Column

Hi @Milbert_Dacudao! So what you need to do is after you add the data column, use an Invoke Method activity. Setup the activity using the info below: TargetType - (null) TargetObject - dataTableName.Columns(“ColumnName”) MethodName - SetOrdinal Then in the Properties tab of the activity, add a parameter: Direction - In Type - Int32 Value - 0 The Value is 0 because it is the index of where you want to move the column. You may want to change it depending on where you want the column to mov…

Regards,

[Anil_G (Anil Gorthi)]

@anh.nguyen

Please check this Article with detailed steps

How to Change the Ordinal of DataColumn

How to change the ordinal or position of the DataColumn to the specified ordinal or position? Is it possible to reorder Columns? If yes, please share a sample script. Issue/Query: How to change the ordinal or position of the DataColumn to the specified ordinal or position? Resolution steps: The above scenario is achievable with the help of Set Ordinal method. Sample Excel/ DataTable Data: Consider the below data [image] Launch UiPath Studio and create a sample process. Ensure to have …

cheers

[anh.nguyen]

Because the specific column is dynamic so I don’t know index just know header col.

[supriya117 (Supriya Allada)]

Hi @anh.nguyen

You can insert column at a specific place by using insert column activity. But this is an excel activity.

[anh.nguyen]

I dont know what place will add col, just can add New Column before specific Column (know header Column)

[Yoichi]

Hi,

The following is a sample which add new column before another column named “colX”.
Hope this helps you

Sample20230407-8L.zip (4.8 KB)

Regards,

[Harshith_Adyanthaya]

You can find the index index of the column you know by using:

dt.Columns.IndexOf(“ColName”)

Then you can add data column and set it to the index you want by using set ordinal function in invoke method.

How to Change the Ordinal of DataColumn

How to change the ordinal or position of the DataColumn to the specified ordinal or position? Is it possible to reorder Columns? If yes, please share a sample script. Issue/Query: How to change the ordinal or position of the DataColumn to the specified ordinal or position? Resolution steps: The above scenario is achievable with the help of Set Ordinal method. Sample Excel/ DataTable Data: Consider the below data [image] Launch UiPath Studio and create a sample process. Ensure to have …

Hope it helps.

Regards,
Harshith

[anh.nguyen]

It worked, but have error

[supriya117 (Supriya Allada)]

You can also give column header name. You can mention the specific column name then there is an option which to set where you need to add after or before.

[Yoichi]

Hi,

We cannot add new column named “AddCol” because it already exists. (Column name must be unique)
Do you want to create table which has 2 or more same name columns?

Regards,

[anh.nguyen]

Hi,
there is no AdCol column at first. after run your code it added AdCol column before QUANTITY (PC/PCS)> if I test change name, still this error

[Yoichi]

Hi,

Can you share content of the datatable at Local panel when workflow stops due to exception?

Regards,

[anh.nguyen]

hi

[Harshith_Adyanthaya]

That column is already present.

Are you using add datacolumn inside a loop? If yes, it is giving error in 2nd iteration.

[anh.nguyen]

Oh yeah in loop. Thank all so much