topic Re: How i can load data in one string with delimiter? in QlikView

How i can load data in one string with delimiter?

Mon, 28 Apr 2014 08:12:50 GMT

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

i need to get something like this:

MK_QSL — Mon, 28 Apr 2014 08:14:58 GMT

Load

ID,

CONCAT(Data, ',') as Data

From....

Group By ID;

UPDATE:

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

Temp:

LOAD ID,

Data

FROM

(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 — Mon, 28 Apr 2014 08:15:39 GMT

Hi,

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

rustyfishbones — Mon, 28 Apr 2014 08:25:40 GMT

Hi,

See the attached qvw

Regards

Alan

Mon, 28 Apr 2014 08:27:06 GMT

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