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; } } }

Concatenate question in Confluence

Dolly Kirubavathi

I have a Jira Filter in my Wiki that returns the below:

Status, Days in Current Status, Key

so a sample data set can look like:

In Progress, 20, XXX-1

In Progress, 20, XXX-2

I would like to use a table transformer to get the output like this(the keys to be concatenated in one row)

Status Days in Current Status Key

In Progress 20 XXX-1,XXX-2

Any ideas? Much appreciated!

Accepted answers

Hi @Dolly Kirubavathi

You mention Table Transformer, which isn't usually a native feature.

Are you using an App to allow for this to happen? If so, which one?

Ste

Katerina Kovriga {Stiltsoft}

Hi @Dolly Kirubavathi ,

I assume that you are using our Table Filter and Charts for Confluence app and its Table Transformer macro.

Please check this recent Community thread - I'm showing how to merge the contents of two separate columns into one column.

And you may also check this thread - it doesn't concern the question, but shows how to aggregate your issues in a more easy-to-read way using the Pivot Table macro.

All comments

Hi @Dolly Kirubavathi

You mention Table Transformer, which isn't usually a native feature.

Are you using an App to allow for this to happen? If so, which one?

Ste

Katerina Kovriga {Stiltsoft}

Hi @Dolly Kirubavathi ,

I assume that you are using our Table Filter and Charts for Confluence app and its Table Transformer macro.

Please check this recent Community thread - I'm showing how to merge the contents of two separate columns into one column.

And you may also check this thread - it doesn't concern the question, but shows how to aggregate your issues in a more easy-to-read way using the Pivot Table macro.

Dolly Kirubavathi

not sure I understand your question. native feature?

the macro table transformer in Confluence is not a native feature?

Dolly Kirubavathi

these are not 2 seperate columns though. It is the same column but 2 seperate rows. any ideas?

thank you!

Katerina Kovriga {Stiltsoft}

Please, give the screenshot of the source table (manually created with dummy data but a screenshot of a table for me to understand what text goes to which cell) and the desired result table.

If you mean that the source table looks like:

Status | Days in Current Status | Key

In Progress | 20 | XXX-1

In Progress | 20 | XXX-2

And you want to get:

Status | Days in Current Status | Key

In Progress | 20 | XXX-1, XXX-2

Then you need a unique field to group your keys. For example, to group all the keys that have the IN PROGRESS status or all the keys that have 20 days in this or that status.

If this is the case, then you may use the Pivot Table macro with a more friendly UI.

Dolly Kirubavathi

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

server

jira

jira-server