Copy and paste one column data in other column in same excel sheet

Help Activities
, ,
1

Copy and paste one column data in other column in same excel sheet

2

Hi @ayushi_jain3
Can you try below xaml
Forum_CopyPasteColumn.zip (75.0 KB)

I hope it helps!!

3

Hi @lrtetala - I tried this earlier, but it is throwing error at read range: “Read Range: A column named ‘MasterTax Company Id’ already belongs to this DataTable.”

4

@ayushi_jain3
Can you show your code

5

image
image626×679 10.6 KB

6

@ayushi_jain3
Try to give another column name

7

Hi @ayushi_jain3

Read the excel sheet and store it in a datatable. Add one column to the datable by using Add Data Column activity. Use for each row in datatable activity and take an assign activity, create a variable and store the column data after that use the update data row activity to update the new column rows. Use the write range workbook activity to write the data in to the same excel.
Check the below image of workflow for better understanding.

image
image880×1203 72 KB

Hope it helps!!

8

Project Requirement is to be the same name