I have a folder structure like this as a source
I want to drop all these excel files into a different folder called Output.
Method 1: When I am trying this, I used copy activity and I am able to get Files with folder structure( not a requirement) in Output folder. I used Binary file format.
Method 2: Also, I am able to get files as some random id .xlsx in my output folder. I used Flatten Hierrachy.
My requirement is to get files with the same name as source an dusing above two methods, I am not able to get the desired results