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'm trying to export data from JIRA to Excel. One of the data fields contain multiple entries that are exported into multiple cells in Excel. Example:
In example above, product_a, product_b, and product_c are exported in 3 separate rows under the impacted_products column.
How can I export the data into a single row or cell in Excel? We've tried using 3rd party products like Looker and manually combining the data in Excel, which is not really ideal.
Is there a command in jql that would allow you to specify, under each change record, the data under specific field should be merged so it wouldn't output as multiple rows in Excel?
You can't control the "structure" or the "format" of the Excel output from JQL. JQL only selects the issues to export.
Instead, try to export the issues with Better Excel Exporter!
You haven't mentioned the field type of the "impacted_products" field, but for multi-value fields, this app typically exports the full value to the same cell. See the "Labels" or the "Components" field here:
In worst case, even if the output is not exactly matches your expecation, it is extremely customizable! You will be able to export multiple values to the same cell, multiple values to multiple rows, etc.
(Discl. it is a paid and supported app developed by our team. Free for 10 users.)
Hello @Jerry Yen
Welcome to the community.
If you use Export to Google Sheets or run a Jira() function in Google Sheets to retrieve the issues from a jira query, your filed with multiple information gets accommodated within a cell.
Please find the output which I get for my sub-tasks within a cell. A ticket can have multiple subtasks like your column has multiple impacted product names: