Forum Discussion
Solved
[Power Query] how to exclude x number of rows at the top when combining csv files
New power query user here (2019 version)! I started by retrieving a single csv file from a folder and transforming the raw data. The data contained 8 rows at the top that I didn't need so I removed ...
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!
