Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
tim_m15
Resolver I
Resolver I

Combine rows with same ID / Split column transformation backward

Hi,

i want to create from these two columns only one in this format.

 

id, CategoryName

c7a..., Importing, NewOne

tim_m15_0-1608713833012.png

 

It is possible to make this transformation in QueryEditor? Nearly a split column-transformation backward. Thank you for your feedback.

1 ACCEPTED SOLUTION

I can not share sample data because i get an error. 


I have one table with dublicated rows. Dublicated becuase one id have different categories. And the goal is to combine the dublicated rows in one with the format you see in my first post. I hope this is understandable.

The challenge is like this:

https://stackoverflow.com/questions/61238999/how-to-combine-rows-with-the-same-id-into-a-list

tim_m15_0-1608715829334.png

 

I want to combine this two columns like this:

ID, Category

1, Green | Blue

 

It looks like the hint in this link works. I had a mistype in my codings earlier.
This is the solution. Anyway, thank you for your help.

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@tim_m15 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

I can not share sample data because i get an error. 


I have one table with dublicated rows. Dublicated becuase one id have different categories. And the goal is to combine the dublicated rows in one with the format you see in my first post. I hope this is understandable.

The challenge is like this:

https://stackoverflow.com/questions/61238999/how-to-combine-rows-with-the-same-id-into-a-list

tim_m15_0-1608715829334.png

 

I want to combine this two columns like this:

ID, Category

1, Green | Blue

 

It looks like the hint in this link works. I had a mistype in my codings earlier.
This is the solution. Anyway, thank you for your help.

amitchandak
Super User
Super User

@tim_m15 , You can do few operation there. What is the logic required ?

The logic is that I have n-IDs and one ID can have n Categories (1-n)...

 

I have dublicate rows and want to combine these rows where the ID have more than one Category

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.