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
Santhosh_V
Regular Visitor

Need to concatenate String values based on User Email Address

Hi All,

 

I have a License report where each user and it will hold multiple lines of entries with respect to their assigned licenses. I would like to combine the User license details for each user and put them on a cell separated by Comma. Also, it will have duplicate license name for each user, We need to pick the unique licenses and need to concatenate them with comma. Below is a sample exported report and the Required output format.

Santhosh_V_0-1679428074213.png

 

Looking for some help on this. Thanks in Advance!!

 

1 ACCEPTED SOLUTION
Padycosmos
Solution Sage
Solution Sage

4 REPLIES 4
Padycosmos
Solution Sage
Solution Sage

In the column containing the original data, you can right click and remove duplicates as shown below and then combine rows:

Padycosmos_0-1679498796590.png

 

Padycosmos
Solution Sage
Solution Sage

Santhosh_V
Regular Visitor

@v-yueyunzh-msft , @FreemanZ @Padycosmos , Any help on this?

 

Thank you!

@Padycosmos,

 

Yes, It combines values but it keeps duplicated values within the licenses column.

Santhosh_V_0-1679463848740.png

Could you please help on this?

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.