Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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;

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

View solution in original post

bbi_mba_76
Partner
Partner

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))