Hi
hope these steps would help you resolve this
–use a EXCEL APPLICATION SCOPE and pass the filepath of first excel and inside that scope use READ RANGE activity and get the output with variable of type datatable named dt1
–then next to this scope activity use another EXCEL APPLICATION SCOPE and pass the file path of second excel and use read range activity and get the output with a variable of type dt2
–we dont need to use BUILD DATATABLE ACTIVITY
–next to this use MERGE DATATABLE activity where in the source mention as dt1 and in destination as dt2
now dt2 variable will have all the data merged together
and when we are using merge datatable we need to ensure these stuffs
like
–both datatable must have same structure of column
–both must have same order of column
–same datatype of column
–same number of columns
only then merge datatable activity will work
kindly try this and let know for any queries or clarification
Cheers @Sevan