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
Hi @Joel Tabares ,
There are two options to resolve your case: the Table Transformer macro and the Pivot Table macro.
Option 1. Table Transformer
Use the following custom SQL query: SELECT T1.'Project', SUM(T1.'Remarks' + " ") AS 'Remarks' FROM T1 GROUP BY T1.'Project'
Option 2. Pivot Table
Recreate the settings from the screenshots below:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.