Forum Discussion
Combing TXT files with different columns
PowerBI123456 each TXT should be structured in some format that has a delimeter, correct? For example, this might be a pipe | a comma , semicolon ; or something that differentiates what is and what isn't a new column? Basically, when you select Folder as Source, you can Combine and Edit. During this process, you select to do your manipulation / transformation on a Sample File or the First File. Herein, whatever you do to the First File or Sample File, Power BI applies the same transformations to all of you TXTs in the folder.
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.