Forum Discussion
[Power Query] how to exclude x number of rows at the top when combining csv files
Why don't you use From Folder connector and adjust only one Transform from Sample File query?
Why don't you use From Folder connector and adjust only one Transform from Sample File query?
Claudia000
Nice blog here about this https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
from Mynda
Thanks for the promotion of my video Riny_van_Eekelen 😀
Thanks for the blog post! Wyn Hopkins@Mynda Treacy The part I found most helpful was Step 6 - I realized I put my transforming queries under my final queries instead of my sample file query. All my files are now being consolidated properly!
Claudia000 glad it was helpful. And thanks Wyn Hopkins for sharing my video!
Wyn Hopkins You're welcome! Always good to promote good work from others 🙂
Perhaps quite obvious, but your video was an eye-opener. So simple, but yet so clear. And it made me forget about the "From folder" option that SergeiBaklan mentioned. Am a relative new PQ user as I have been on a Mac since 2011. Still am, but running W10 virtually on Parallels for the past 9 months or so. Still learning, every day!
