Add new Column excel form another excel

Help Activities
, ,
1

hi everyone,
i need your advice for my task.
image

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

image
image850Ă—197 4.02 KB

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

image
image1366Ă—758 136 KB

but the result I get is exactly like this

image
image763Ă—201 2.88 KB

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:

2

Hi @WICAKSONO_Hanif ,

have a look at this,

3

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.

4

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

5

Hi,

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

image
image712Ă—534 17.3 KB

image
image1092Ă—610 50 KB

6

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

7

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

8

Use Append Range. It should work with that.

9

hi @csmart
can you show me how it works?

10

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

The Source
image

Need To Add

image
image850Ă—197 4.02 KB

11

hi @Eric_Wong_Test,

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

12

Alternatively you can try this one also.

Copy Range.xaml (7.0 KB)

13

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