How to insert a new empty column in between two columns

[Guest0203]

I am very new in working with Datatables so please help me

Hi all, I have an excel like this and I want to input a new column after the “Expiry Date” column.
The index of the “Expiry Date” column is dynamic so i want to detect where the column is and add a empty column after the “Expiry Date” column.
Furthermore, the first three rows have to kept there for some confidential reasons,

SCN Fourth.zip (16.0 KB)

[Lakshay_Verma]

@Guest0203

Hey

Add new column at specific position in excel

Hi Hope this would help you for sure Here the set ordinal is used to add the datacolumn at desired position and here in the xaml attached will have set at Column B with 1, you can set as 4 To add at your desired position Here you go with that sample xaml add datacolumn.zip (2.6 KB) Cheers @vamsikrish28

[Guest0203]

[balupad14 (Balamurugan)]

Hi @Guest0203,

Check this one.

Insert/Delete Columns

Thank you
Balamurugan.S

[Lakshay_Verma]

Insert a Column into a specific position in DataTable

Hi @naotosx, I have specified the position of the column using the method setOrdinal in the invoke method activity: [image] The DataColumn.SetOrdinal(Int32) method changes the ordinal or position of the DataColumn to the specified ordinal or position. When you change a column’s ordinal, the column is moved to the new position in the collection of columns. Any columns between the previous and new ordinal will be renumbered, to adjust for a column’s new ordinal. Best Regards, Susana

@Guest0203