7. Data Cleaning A–Z in Power Query
7.20 Combine Files from a Folder (Quick Version)
When the same export arrives every month (Blinkit_Orders_2025_01.csv, Blinkit_Orders_2025_02.csv …), put all files in one folder and use Home › Get data › More… › Folder. Then filter the file list (Extension, no ~$ temp files) and click Combine Files on the Content column. Power Query creates helper queries and a combined table with a Source.Name column. Steps that must run on each file (removing title rows, renaming headers) go into Transform Sample File.
Module 9 is a full step-by-step walkthrough of this process, using monthly bank statements. It covers the helper queries, deriving the month from the file name, files with an extra column and auto-refresh.
Practice task
Lakshat theva, combine three monthly Amazon Now CSVs from a folder. After reading Module 9, add a File Month column extracted from Source.Name.
Ravindra Bagale's Tip
The most common folder mistake is not filtering out hidden and temporary files (such as ~$Jan.xlsx), which breaks Combine Files. Filter the file list on Extension and Attributes before combining. The full walkthrough is in Module 9. Try it once more, then move on.
Ravindra Bagale's Tip – मराठी
सगळ्यात common folder चूक म्हणजे hidden आणि temporary files (जसं ~$Jan.xlsx) filter न करणं, त्यामुळे Combine Files तुटतं. Combine करण्याआधी file list वर Extension आणि Attributes ने filter लावा. पूर्ण walkthrough Module 9 मध्ये आहे. पुन्हा एकदा करून बघा, मग पुढे जा.
Ravindra Bagale's Tip – हिंदी
सबसे common folder गलती है hidden और temporary files (जैसे ~$Jan.xlsx) को filter न करना, जिससे Combine Files टूट जाता है. Combine करने से पहले file list को Extension और Attributes पर filter करो. पूरा walkthrough Module 9 में है. एक बार फिर करके देखो, फिर आगे बढ़ो.