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.
Can anyone please help me on this?
Hitesh M. Jeswani