Forum Discussion

aurkmez's avatar
aurkmez
New Member
3 years ago
Solved

Load txt as table in powerquery

Hello everyone,

 

How would you load this txt as a table? I could transform only the Customer ID column but I need to divide the rest as well.

 

Need Help
  • aurkmez's avatar
    aurkmez
    3 years ago

    I was able to solve this with some effort, if someone is curious I can send my .pbix file. Thanks!

2 Replies

  • aurkmez's avatar
    aurkmez
    New Member
    3 years ago

    I was able to solve this with some effort, if someone is curious I can send my .pbix file. Thanks!

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar
    3 years ago

    Hi aurkmez,

     

    When you select the Source step, go to the View tab on the Ribbon and enable "Monospaced"

    Do your column values align?

     

    If not, please share a sample file