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

How can I parse a column with a list of comma separated values and create new rows for each

Adam Petrie_chbc0n

I am presently using Table Transformer on Jira data and getting a Linked Issues for a list of Epics of interest. Looks like this sample.

When there is more than 1 linked issue I'd like to create a row in my table for each of the linked issues and duplicate all the other columns.

Help appreciated.

Accepted answers

Stiltsoft support

Hi @Adam Petrie ,

If you are talking about the Table Transformer macro provided by the Table Filter, Charts & Spreadsheets for Confluence app, you may check this Community thread. Seems that it's exactly what you are trying to do.

All comments

Stiltsoft support

Hi @Adam Petrie ,

Jim Knepley - ReleaseTEAM

I think the SQL-based transformers use the H2 database internally, and splitting a string in H2 is a little involved.

If you are using the SQL-based table transformer, could you provide the SQL query that your table is based on? Hopefully, we can unwrap what's building Linked Issues at the source, instead of trying to manipulate the string contents of those cells.

Jim Knepley - ReleaseTEAM

(ignore this, the answer that @Stiltsoft support posted is better)

Adam Petrie_chbc0n

I'm looking at the referenced thread. It does appear to be exactly what I'm trying to solve. When I try to implement I'm getting an error I do not understand.

Adam Petrie_chbc0n

underlying table I'm trying to run above query on

Adam Petrie_chbc0n

The values come from Jira are coming has HTML links. Is there another step to be taken so they are only text?

Welcome!

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

Quick Links

Find more posts tagged with

confluence

filter

table

table-filter

table-filter-and-charts

table-transformer

table-filter-charts-spreadsheets

unknown-hosting-type

confluence-unknown-hosting-type