Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Table Transformer - concatenate data from multiple rows based on criteria

Joel Tabares
Contributor
September 24, 2020

Hi,

SQL functions in Table Transformer is limited that i'm having trouble concatenating/merging data from multiple rows.

 

Table

Project  | Remarks

P1   |  The quick brown

P1   |  Fox jumps

P2   |  Over the

P2   |  Lazy dog

 

I need it to produce the output below:

Project | Remarks

P1   | The quick brown Fox jumps

P2   | Over the Lazy dog

 

1 answer

1 accepted

2 votes
Answer accepted
Katerina Kovriga _Stiltsoft_
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.
September 25, 2020 edited

Hi @Joel Tabares ,

There are two options to resolve your case: the Table Transformer macro and the Pivot Table macro.

1.png Option 1. Table Transformer

Use the following custom SQL query: SELECT T1.'Project', SUM(T1.'Remarks' + " ") AS 'Remarks' FROM T1 GROUP BY T1.'Project'

2.png 3.png Option 2. Pivot Table

Recreate the settings from the screenshots below:

4.png 5.png

Joel Tabares
Contributor
September 25, 2020

This is perfect. Thank you so much Katerina.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events