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

[Stiltsoft support · Accepted solution]

Hi @Schmidl82 ,

Please try the following:

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

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!