cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Normalize data

‎03-14-2022 07:45 AM

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.

Message 1 of 2
120 Views
0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

‎03-14-2022 08:06 AM

@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



View solution in original post

Message 2 of 2
85 Views
0
1 REPLY 1
amitchandak
Super User
Super User

‎03-14-2022 08:06 AM

@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



Message 2 of 2
86 Views
0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

View All
Top Solution Authors
View All