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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.