Table Transformer - concatenate data from multiple rows based on criteria

[Joel Tabares]

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

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

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:

[Joel Tabares]

This is perfect. Thank you so much Katerina.