How i can load data in one string with delimiter?

[#1]

I need to do something like implode in php,i have some data on load in table and i need to group data in one string.THX for helping

Example:

From this table

ID	Data
1	5
1	6
2	7
3	8

i need to get something like this:

ID	Data
1	5,6
2	7
3	8

[MK_QSL · Accepted solution]

Load

     ID,

     CONCAT(Data, ',') as Data

From....

Group By ID;

UPDATE:

===========================

Temp:

LOAD ID,

     Data

FROM

[http://community.qlik.com/thread/115770]

(html, codepage is 1252, embedded labels, table is @1);

NoConcatenate

Final:

Load ID,

  Concat(Data,',') as Data

Resident Temp

Group By ID;

Drop Table Temp;

==============================

[bbi_mba_76]

Hi,

maybe you could use a group by and the concat function.

[rustyfishbones]

Hi,

See the attached qvw

Regards

Alan

[#5]

Thx) i think about concat,but i forgot about group by))