Cell Delimitation Does Not Work

Bela.Majoros
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 10, 2023

Hi,
I have been working on a table where one field could be picking up multiple values.
(Release).

JIRA (JQL), in a table toolbox.
Filter > Table Transformer > Pivot Table > JIRA.

When I create a pivot table, I tick the cell delimiter as ',', but it does not work.


When I write a code like this:

[...]
CASE WHEN CAST(T1.'Release' as text) LIKE "%UK%" THEN "Impacted" ELSE "Not impacted" END AS 'ReleaseChanges',
[...], it has no impact.

Similarly to this clause:

[...]
REPLACE(T1.'Release', ', ', "|") AS 'DelimitedValues',
[...]


Nothing happens and values are still shown  like this: value1, value2...

like it does not detect the comma - probably cause it's multiple value field.


 

1 answer

2 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 19, 2023

Hi @Bela.Majoros ,

Seems that there is certain misunderstanding how the cell value delimiter works for the Pivot Table macro, please check this example (if the anchor doesn't work navigate to the "Set cell value delimiter" section).

Let's move to our support portal (it's based on Jira Service Management and it's confidential).

Please attach the screenshot of your Jira Issues macro in a published state (with visible headers and several rows of data). And please specify once more what is the end goal (to place your releases in separate cells, to put statuses based on release names, etc.).

We'll recreate your table and help with the solution.

Bela.Majoros
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 21, 2023
Like # people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events