Copy data from some of the columns in sheet1 to some of the columns in sheet2

Help Studio
, ,
1

Hi All,

I have a scenario where I have to copy, “Column 2, Column6, Column10” from “Sheet1” to “Column3, Column8, Column15” in “Sheet2”

Is there a way to do this in single go?

2

Hello @Krithi1

Can you try Auto fill range activity?

+Sheet1!A1 . This formula can copy the value of cell A1 in sheet1.

3

I am sorry, didn’t get that @Rahul_Unnikrishnan

Can you please elaborate or send a sample xaml?

4

Can someone help here?

5

Hi @Krithi1,

I’m not sure if this is the way you’re looking for, but I’ll suggest it anyway.

1-Get the entire column into a list with the read column activity.
2-Create an empty dt with the Build datatable activity.
3-Import the list you created into your dt table.
4-Delete the column in the different sheet you want to change.
5-Print your created datatable into the area you deleted.

image
image431×799 23.2 KB

You can manage this operation for more than one sheet by setting up a loop in the Excel scope.

Regards,
MY

6

Can this be achieved using a select method in single go? This is what I am mainly looking for