Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
4 years ago

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...
Need Help
Show and Tell
Tips and Tricks
TheoC's avatar
TheoC
Community Champion
4 years ago

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.

PowerBI123456's avatar
PowerBI123456
Post Partisan
4 years ago

Yup, I got that part. But the issue is that the first  file might have 70 different columns, but the second file has 80. What is happening is those 10 extra columns from the second file are not coming over and there is mismatch since the extra columns are in the middle of the file.