Copy column data with different name to different sheet in specific column

[anon54733438]

Hi,

Need some help here for my automation project

Problem:-

1)How to copy column data to different sheet? For example, copy column A in sheet 1 to column B in sheet 2?

2)Lets say, we already successfully solve this first problem, how to do same with another sheet?
For example, in sheet 3

Sheet 2

Sheet 1

Sheet 3

Expected Result

[Yoichi]

Hi,

Hope the following sample helps you.

Sample20220328-3.zip (10.9 KB)

Regards,

[anon54733438]

This workflow will read the whole data table. How about to get only one column of the data table only ?

[Yoichi]

Hi,

We can extract just needed column using ToTable method as the following. Can you try this?

dt2 = dt2.DefaultView.ToTable(False,{"Name"})

Regards,

[anon54733438]

@Yoichi

dt2.DefaultView.ToTable(False,{"Name"})

I have try this.

But the both datatable is not merge.

Only data table 2 is at the sheet 1

[Yoichi]

Hi,

Is the both column name same?

I’ll attach a sample as the following. Can you check this?

Sample20220328-3v2.zip (21.1 KB)

Regards,

[anon54733438]

I have do some mistake at input.

Finally it works.

Thanks man,for your help.

Any idea to loop through to many sheet? For example, 15 sheets.

[Yoichi]

Hi,

@anon54733438

Any idea to loop through to many sheet? For example, 15 sheets.

We can use GetWorkbookSheets activity as the following.

It might be necessary to skip specific sheet using IF activity.

Regards,

[Yoichi]

Hi,

FYI, the following sample will work for multiple sheets.

Sample20220328-3v3.zip (25.0 KB)

Regards,

[anon54733438]

Thanks bro.

You have made my day better.