Power Query - import from folder text files. Load in one column.

[5ra4ka]

Hi everyone,

Sorry for my question but I couldn't found an answer for it.

So problem is - I'm importing data in power query from folder with 3 .txt files. Each of this file should contain 3 columns. (they are separated by TAB).

Then I am removing all other columns except binary. After that expanding this binary column and getting all data into on column. Where it should be in three columns. This is how others is getting data but for me it doesn't work.

I am using office 2013.

When I am importing as .txt file not folder then it works, but in this case I need from folder to import.

Hope someone will help me to understand what could be wrong.

Than you in advance!

 

[Matt Allington]

If the single file works, then my technique here should help you. Combine Excel Workbooks with Power Query – Method 1 - Excelerator BI