• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query combine txt files from a folder/folders


New Member
I have one file that contains legacy data (C:\Accounting\Legacy Data). I want to add them to each file in the folder (C:\Accounting\Data Source) first then combine them into one file. I can combine files from a folder but to add data to each of them first then combine them that gives me problem. I appreciate your help, please see attached files/folder.

Thank you,



Well-Known Member
Try refreshing the table in the attached.
It uses the 20101231.txt file by name, expecting to see it in C:\Accountancy\Legacy Data
and whatever files (ie all files) it finds in C:\Accountancy\Data Source (this could be refined to specific types of file if necessary).
This does not change any of the source files.