How do i add new columns with data into an existing datatable?

[Martin_Pan]

i have my final output as this

but i was expecting the new columns with the data to be added in between Sample Code column and the DUTCH column, like this

How do is specify it to be in between those columns that i want to add in new data?

[priyankavivek (priya)]

just mention it in writerange,if have any further detail let me know …

[Martin_Pan]

i meant how do i insert this new datatable of values into an existing datatable between specific columns

[priyankavivek (priya)]

as you need to add the new column am i right?
add build datatable (mention what are all the column you have to insert)
add assign activity for those columns which you need to add
then finally writerange

[Martin_Pan]

i need to add each column in my new datatable into the existing datable between specific columns

[vikaskulhari]

@Martin_Pan, you can use add data column or write range activity of excel. To add column at specific location, you can refer below link-

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

Cheers!!

[priyankavivek (priya)]

try with this as add data column activity as @ vikaskulhari said

[Martin_Pan]

can i have a set number of columns together infront rather than just 1 column at a time?

[vikaskulhari]

You can set one bye one or loop through it.