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?

[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.

[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]

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

[Craig Nodwell]

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 Alterman]

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

[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.

[Shikha Saka]

Ok thanks!