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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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