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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
eloomis
Advocate II
Advocate II

Append columns of the same table

I have a table like this:

 

ProjectID | Project Manager

12345        John Doe

67890        John Doe, Jane Doe

 

 

I need to have a column of single project managers, with their correlated project ID. So I split Project manager on comma delimiter and now I have two columns Project Manager.1 and Project Manager.2. How can I append Project Manager.2 to 1, retaining the projectID, and hopefully not generating a new query to be kind to my file size. Thank you!

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @eloomis ,

 

When you split the [ProjectManager] column using the ", " delimiter, expand the advanced option in the split dialog and you'll see you can split the values to new rows, instead of columns:

BA_Pete_0-1673538830228.png

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

5 REPLIES 5
serpiva64
Super User
Super User

Hi,

you have to split column by delimeter choosing split into rows

serpiva64_0-1673538845377.png

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

 

Phenomenal, thank you!

BA_Pete
Super User
Super User

Hi @eloomis ,

 

When you split the [ProjectManager] column using the ", " delimiter, expand the advanced option in the split dialog and you'll see you can split the values to new rows, instead of columns:

BA_Pete_0-1673538830228.png

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Thank you so much

Fantastic, thank you!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors