You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have been working on a table where one field could be picking up multiple values.
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.
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.