Add new Column excel form another excel

hi everyone,
i need your advice for my task.

i want to add data column B1:D8 to result excel like the example below

I have tried with the add column and for each activities as below

but the result I get is exactly like this

i want result excel column Item still there not replaced, So the data adds to the right

thank you for spending your time to help me :slightly_smiling_face:


have a look at this,

Hello @WICAKSONO_Hanif
You can use the method SetOrdinal, with this you can move the index of the column.

Let me know if that works.

hi @Manuel_Dominguez ,
can you show me how it works?


Use Invoke Method with MethodName =“SetOrdinal” and TargetObject is your result datatable and the columns you want to move the position and in Parameters give the new position and check it out

hi @Boopathi.M
it looks like target object is only for certain column name when read range data. what i want is read range column with data condition which will be flexible.
because the data will increase every day, meaning that the column names will changes when different dates

thanks for you advice

hi @Kola_Mounika,
I’m not getting the result I want, any other suggestions?

Use Append Range. It should work with that.

hi @csmart
can you show me how it works?

Excel_Add_Column.xaml (17.0 KB)
Please Try and use dt2 for the result

The Source

Need To Add

hi @Eric_Wong_Test,

amazing :heart_eyes:,
thanks for your help, it works

Alternatively you can try this one also.

Copy Range.xaml (7.0 KB)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.