Add two excel sheet

Help Studio
, ,
#1

I have two excel sheets and my requirement is add those two excel sheet and write it into single excel sheet.

Capture5
Capture5486×530 6.66 KB

Capture6

I use Merge Data Table Activity and get the output which is not my requirement.
I want “Customer”, “Customer A/C no.”, “Delivery”, “Customer PO Date” for every “Column1”.

Please guide me.

Thanks & Regards,
Nirmalya Sarkar

#2

Hi @nirmalya.sarkar

Use excel application scope and based on hot key use Ctrl+A and use Ctrl+c and use ctrl-v in

Thanks
Ashwin.S

#3

@AshwinS2 ,

I am sharing my workflow with you. Can you tell me where I have to change??
Final.xaml (13.5 KB)

Thanks & Regards,
Nirmalya Sarkar