Forum Discussion
Merge multiple excel files into different tabs of one workbook using Power Query on Mac
Here is the variant, but made on Windows
With the help of TTodorov , I finally figured out the correct buttons to press in power query UI and find a painless way to get this done. (Many thanks again for offering a long-term solution for this nuisance!)
Mainly, first follow below to hack the source folder on mac
https://www.youtube.com/watch?v=chBlyDrejHo&t=318s
Then follow below to select the columns I need based on an external config:
https://www.youtube.com/watch?v=-owZ7G880Jc
Come up with something like the attached.
Still struggling to figure out how to write ForEach loop. (and I suspect my Mac is partially to blame here). so I will just live with pressing buttons for now.
Here is the variant, but made on Windows
- It works on Mac! I just have to add a step to filter by file extension because on Mac we have this ".ds_store" file that cannot be filtered out by "#"Filtered Hidden Files1" = Table.SelectRows(GetContent, each [Attributes]?[Hidden]? <> true),".
The code is so well structured that I finally start to feel brave enough to open the Advanced editor to try to write something.
Thanks a lot!rachel , you are welcome, great to know it works on Mac.