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



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 one 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. Maybe some settings must change?

Than you in advance!


Answer the Question

You must create an account to use the forum. Create an Account or Login