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
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
@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