Forum Discussion
PowerBI123456
Post Partisan
Post PartisanCombing TXT files with different columns
Hi - I am trying to combine several TXT files that have different columns, so not all the columns are being captured. I found a few ways of doing it, but that assumes the header is already establishe...
TheoC
Community Champion
Community Champion
In Power Query, you can use Merge to bring them altogether. Basically, when you have one or more columns that you want to bring together, you can merge them.
Let me know if you want me to provide further steps.
Theo 🙂
PowerBI123456Yes, please! How do you do that exactly? Thank you so much?
- TheoC
Here is a basic tutorial: https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9
Go to the "Perform a Merge Operation" section.
Hopefully this helps.
Theo 🙂
- PowerBI123456
TheoC Thanks! but this requires me bringing in one file at a time right? The folder of files I am bringing will have a new file each week.