Forum Discussion
Combining two CSV when there are lots in a folder
Hi there,
I need to combine two files that are part of a lot of exported CSV that end up in a folder on our filer.
I can see where it combines all the files in a folder, but how do I just tell Power BI to combine the two that I need and ignore tha rest.
Thanks.
Hi Anonymous
You can use "Folder as Source" and then apply a "text filter" on the name of the specific files in the folder. This will then eliminate everything else other than the two files you're after.
Hope this helps! 🙂
Theo
A couple of links that may provide you with additional guidance:
- https://community.powerbi.com/t5/Power-Query/Connecting-to-Folder-but-filtering-by-file-name/td-p/204709
- https://powerbi.tips/2016/06/loading-data-from-folder/
- https://powerbi.tips/2016/04/folder-of-files-loaded-to-power-bi-desktop/
3 Replies
- TheoC
Community Champion
Hi Anonymous
You can use "Folder as Source" and then apply a "text filter" on the name of the specific files in the folder. This will then eliminate everything else other than the two files you're after.
Hope this helps! 🙂
Theo
A couple of links that may provide you with additional guidance:
- https://community.powerbi.com/t5/Power-Query/Connecting-to-Folder-but-filtering-by-file-name/td-p/204709
- https://powerbi.tips/2016/06/loading-data-from-folder/
- https://powerbi.tips/2016/04/folder-of-files-loaded-to-power-bi-desktop/
- TheoC
Anonymous a pleasure mate. I know what you mean about selecting what you wanted and move on. Filtering out is kind of like it but more deselection rather than selection I guess haha.
Either way, glad it worked mate! 🙂