Excel doubt merge

I have 2excel files in that i have 2 sheets for both 2 Excel files sheet names r common
I need to merge data can any one help me on this

@Arya_Squares
what does the data look like?

can you upload the excel?

Hi @Arya_Squares ,

Welcome to the Community !

Please refer to this link and follow it and make changes as per your sheet and file manes and column names:

Hope this helps.

Thanks.

It has 42 columns in the both the sheets
1 sheet name is exception
And other sheet name is completed

use this sequence @Arya_Squares
Sequence.xaml (9.0 KB)
change workbook path to your own path

image

@Arya_Squares here
Sequence.xaml (11.8 KB)

replace excel1Path and excel2Path with your own path
note - this sequence will merge excel1 to excel2

Hi @Arya_Squares, I hope you are doing well.
To answer your problem firstly, I wanted to know the 2 sheets which you have mentioned “exception” and “completed” do they have common column values like “id” or “process_name”. If so, I would recommend you to use join datatable by giving which column values matches instead of merge datatable.
And if no common row values are there you can proceed with merge datatable.

Thank You,
Shubham Dutta

Hi @Arya_Squares

Try out this logic:

image

XAML file

MergeDT.xaml (6.9 KB)

Regards
Gokul