nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Splitting JIRA labels into multiple columns

Craig Alterman

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?

Accepted answers

All comments

Craig Nodwell_7eve9b

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?

Aron Gombas _Midori_

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.

Craig Alterman

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

Craig Alterman

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

Nikita Kamai

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.

Shikha Saka

@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?

Katerina Kovriga {Stiltsoft}

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

jira

table