Forum Discussion
Power Query | Combining binaries results in lost data from text file
Just a follow up to my earlier response.
It looks like the text file is fixed width.
I pulled it in using the following steps (See attached image and file)
Note: I didn't change the data type column in the last step as my system isn't set up for US format
Hi Wyn,
Thanks for your response. The challenge I am having is related to importing multiple text files (same structure and format as the previous attachment) and trying to subsequently consolidate them. I do not have the original code from the previous version as my machine crashed recently (which is why I had to install the latest and greatest version of Power Query). I've attached the previous documented steps I used previously, that of course are no longer working with the new version. This should hopefully give some insight into the full process. Although the overall flow is completely different, my primary challenge is the omission of data in the text file which of course drives the numbers off when consolidating the file. Thanks for looking at this with me.