Merging two excel sheets into one

Help Studio
1

Hi all,

I have two excel sheets and i need to merge the contents of the two sheets into one. I am attaching an example excel. please help me out.
The sheet 1 and 2 contains the data and the sheet 3 contains the merged data. Input is sheet 1 and 2 and output should be like sheet 3. Thanks
New Microsoft Excel Worksheet.xlsx (11.4 KB)

2

Hi @karan_kapoor1

Use read range for 2 sheets and store it in 2 datatables variable

use merge datatable activity and store it in 3rd datatable variable

use write range activity and write it in sheet3

3

@karan_kapoor1

Check as below

image
image1899×673 47.5 KB

Hope this may help you

Thanks

4

the header 1 column has to be merged together like how i have done it in the example excel

5

Please go through the example excel

6

@karan_kapoor1

Yes, but that was an extra column so you can use Remove Data column activity

Hope this may help you

Thanks

7

yes i can use but with your method i am only getting 4 rows in output and i should get 6 rows in output as there are 6 unique header1 values

8

@karan_kapoor1

Check as below

image
image1903×720 52.4 KB

Select “Full” in Join Type

Hope this may help you

Thanks