Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,965
Community Members
 
Community Events
176
Community Groups

Splitting JIRA labels into multiple columns

I have a JIRA table of issues that each contain a group of labels.  I need to be able to analyze the labels independently, thus have them separated into separate columns.

The string of labels appears in confluence as one long string with spaces between each label such as "Label1 label2 label3"

Any idea how to do this using table transformer? or another method?

3 answers

Hello, @Craig Alterman 

This is Nikita from Stiltsoft.

You can swiftly split the values with Table Transformer without any additional macro or out-of-Confluence steps and then proceed with the values analytics. Here you can see how it it's done.

Additionally, you can resort to Pivot Table usage to splilt values and aggregate right away by configuring cell value delimiter setting in the macro browser.

In case you will need additional help, you can always contact us via a support ticket.

0 votes

If it doesn't have to dynamic, but a one-time thing, you could export the issues to Excel, then split the "labels" value at the comma characters to multiple columns, then copy-paste or import the Excel spreadsheet to the Confluence page.

This is something ive considered. I was hoping to avoid it in order to make what im trying to build scalable 

0 votes
Craig Nodwell Community Leader Jul 29, 2022

Hi @Craig Alterman welcome to the community.
Quick question, are these labels coming from the Jira issues?  Re: is this part of the configuration of the Jira macro output?

@Craig Nodwell - Yes, they are part of the JIRA table macro output

@Craig Alterman were you able to get this resolved? I am looking at something similar but not got results. split() doesnt seem to be working. The link above seems to be adding another row for each label which will not work for my case. 

@Katerina Kovriga _Stiltsoft_ any other alternate or suggestions?

Hi @Shikha Saka ,

Unfortunately, there is nothing new from our side: as Nikita has mentioned before, you may split labels by spaces and place every separate label in a separate row (it can be later useful for filtering by every particular label and not the whole string) or set the corresponding value delimiter to aggregate/count each label separately through the Pivot Table macro.

Ok thanks! 

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events