Forum Discussion
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 established. My problem is that I have to promote the headers after I combine. Any tips please?
11 Replies
- TheoC
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 🙂
