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

Table Transformer - Sorting out multiple values from a column

Schmidl82

Hi everybody,

I have added the Jira Filter Results Makro to a confluence page.

The cells in one column contain multiple values (components defined in Jira),
e.g. values like A10, B12, I30 and at the same time values like 08/15, 10/12.

I cant find a way to extract the values with the "/" and write them in one new column.

I use the table transformer macro for other operations like conditional formating,

Can anybody help?

Thanks in advance!

Christian

Accepted answers

Stiltsoft support

Hi @Schmidl82 ,

Please try the following:

Tue 4-1.png

SELECT *,
MATCH_REGEXP(T1.'Component', "\d+/\d+", "g")
AS 'Component with /'
FROM T*

Tue 4-2.png

Here the regex stands for number/number, but you can adjust it as you need.

Hope this helps your case.

All comments

Stiltsoft support

Hi @Schmidl82 ,

Please try the following:

Tue 4-1.png

SELECT *,
MATCH_REGEXP(T1.'Component', "\d+/\d+", "g")
AS 'Component with /'
FROM T*

Tue 4-2.png

Here the regex stands for number/number, but you can adjust it as you need.

Hope this helps your case.

Schmidl82

Thanks you so much!

One additional question: The "Component with/" now containes of one string.

Can I at least add a blank in between the values.

I'd like to filter the column by component sepertely (e.g. 08/15). I'm not sure if the blank helps anyway.

I hope I could explain it correctly,

Thanks!

Christian

Stiltsoft support

Hi, you need commas to filter your values separately (just as it is shown on the screenshot).

Then you wrap the Table Transformer macro in the Table Filter macro and set a Dropdown filter for the 'Component with /' column.

Then you go to the filter settings (click on the cogwheel near the filter in the macro browser) and set "comma" as a cell value delimiter.

You may check this abstract of our documentation: https://docs.stiltsoft.com/tfac/dc-server/table-filtration-42239755.html#Tablefiltration-DropdownFilter

Scroll a little bit down from the anchor and you'll see an example with screenshots.

Hope it is what you meant.

Schmidl82

Thank you so much for your support!

Welcome!

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

Quick Links

Find more posts tagged with

confluence

sql

filter

table

table-filter

table-filter-and-charts

table-transformer

table-filter-charts-spreadsheets

unknown-hosting-type