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
StuartSmith
Power Participant
Power Participant

Split Column of varying number of items by Delimiter

I have a column I need to split by colon, but each cell in the column has a varying number of items.  In the Advanced section of "Split Column by Delimiter", there is the option to select the number of columns to split into, but if the number is to low, it doesnt split the column enough and if the number is too high, it splits into too many empty columns.  How can I split the column dynmically, depending on the number of items in a call.  Hope that makes sense.

 

Item
1, 2, 3
4
5, 6, 7, 8
9, 10

So it would split like this...

Item_1Item_2Item_3Item_4
123 
4   
5678
910  

 

Thanks in advance.

1 REPLY 1
amitchandak
Super User
Super User

@StuartSmith , My advice would be split into rows and then use matrix visual to display it

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.