Forum Discussion
Custom Function for aggregating multiple sources into single tables.
Hi all, I'm wanting to know if it's possible to combine multiple sources in a function so I can call it to transform more than 1 excel file and, if possible, get some help with writing it. I'm able ...
It's certainly possible but you need to approach this in two stages
1. Create a function that iterates through all sheets of a given Excel file and concatenates the content. Decide if you want to include the sheet name.
2. Create a function that iterates through all Excel files, calls the above function for each, and concatenates the result. Decide if you want to include the file name.