Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How i can load data in one string with delimiter?

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

IDData
15
16
27
3

8

i need to get something like this:

IDData
15,6
27
3

8

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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;

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

View solution in original post

4 Replies
MK_QSL
MVP
MVP

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
Partner - Specialist
Partner - Specialist

Hi,

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

rustyfishbones
Master II
Master II

Hi,

See the attached qvw

Regards

Alan

Not applicable
Author

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