Concatenate many rows from the same table

[oanalung]

Hi, 

I want to concatenate many rows into one based on two columns having the same value. 

All the data is in the same table. 

Example 

User_Id               Description             Flag       Date

1                               Text1                       0                2020-01-01

1                                Text2                      0               2020-01-01

1                               Text3                       1                2020-01-01

I want to achieve: 

User ID               Description             Flag          Date

1                               Text1, Text2          0                2020-01-01

1                               Text3                       1                2020-01-01

based on user_id being the same and same value in column flag. 

as script I have: 

LOAD 

user_id as [User ID],

description as [Description],

flag as [Flag]

date as [Date];

SQL 

Select

user_id,

description,

flag,

date from table_name; 

[Aurelien_Martinez]

Hi,

You can try with the concat function

LOAD 

user_id as [User ID],

Concat(description, ', ') as [Description],

flag as [Flag]

date as [Date]

Group By

  user_id ,

  flag ,

date

;

SQL 

Select

user_id,

description,

flag,

date from table_name; 

[oanalung]

Hi, 

thank you very much, I have tried this and it looks like it's not running, I get invalid expression. 

any idea why? 

[Aurelien_Martinez]

Perhaps a missing comma after the line "flag as [Flag]"

[MarcoWedel]

What about the Date column?

[oanalung]

Yes, this is working, thank you very much. 

Is there another way to achieve this in the script without using the group by? 

Just concatenating everything if the User_id column has the same value. 

thank you!