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!

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

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]

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]

[Katerina Kovriga _Stiltsoft_]

You may try the following settings for the Pivot Table macro then:

[Dolly Kirubavathi]

Yay!!!! Thanks much!!!! It worked!

[Stephen Wright _Elabor8_ · Accepted solution]

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

[Dolly Kirubavathi]

not sure I understand your question. native feature?

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