Cell Delimitation Does Not Work

Bela Majoros

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.

 

Stiltsoft support

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.