Forum Discussion
Combing 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...
I can try recreating the situation with dummy data if that helps. Appreciate your help!
PowerBI123456 that would be great if you can. In the meantime, please watch this video: https://www.youtube.com/watch?v=JAw4rrpc7vk it will hopefully provide you with the necessary steps to follow and apply to manage the various columns.