Add column between two columns

[sushmithaelluru (sushmitha)]

Need to add column in between two columns( ACD# and Category ), but using add column activity the column is get added at the end of all columns. “Can I know which activity should use to add in between two columns”!!

The below attached are the xaml file and the screenshot of the excel sheet.

insercolumn.xaml (8.3 KB)

Thanks in advance.

[Pablo_Sanchez (Pablo Sánchez Hernández)]

Hi @sushmithaelluru,

Try to read the first part of your Excel file and save it as DT1, then read the second part and save it as DT2.

Now, write the DT1. After this, insert your new column as you are doing, and then, write the DT2.

Hope it helps you.

Bests,
Pablo

[sushmithaelluru (sushmitha)]

Sorry @Pablo_Sanchez, can you once brief your point mentioned.

Thanks.

[Rashmi (Rashmi Pareek)]

You can add column between two columns by using invoke method [ SetOrdinal ]

example attach : InsertColumn.xaml (7.3 KB)

[Rashmi (Rashmi Pareek)]

Change column position accordingly