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

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors