Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Normalize data

Good to all,

I am trying to normalize a downloaded database in .txt.

The truth is a bit complicated for me because when choosing the different types of separators I eliminate columns when using the option of tabper seaparador.

matam93_0-1647268828571.png

Help please.

  • amitchandak's avatar
    amitchandak
    4 years ago

    Syndicate_Admin ,
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    You need to try Split by Delimiter in power query

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Syndicate_Admin ,
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    You need to try Split by Delimiter in power query