I am currently using merge datatable activity to merge 3 different excel files with same number of columns and same column name but variable number of rows. But for some reason only last excel file data is getting added to the datatable.
I am using Read Range activity in a loop to read through all 3 excel files.
Thanks for the quick reply. but I am not looking to create a new excel file. I want to dynamically loop through the files and create a datatable since I have many folders to iterate through and all of them contain multiple excel files. Creating a new excel file for each and every folder is not feasible for me.