How to merge 2 or more tupels to one?

[#1]

Hello everybody,

I'm new to QlikView and I have a problem for which I couldn't find Informations with Google.

I have a table like this:

Column A	Column B
1	a
1	b
1	c
2	a
2	e
2	f

Column A	Column B
1	a b c
2	a e f

I just want to convert the text values in B for each value in A to one row. Any Idea?

[marcus_sommer]

Try it with:

load [Column A], concat([Cloumn B], chr(10), recno()) as [Column B]

from YourSource group by [Column A];

- Marcus

[muthukumar77]

Hi,

Refer this app.

[#4]

Directory;

test:

LOAD Id,

       Concat(distinct Name ,',') as Name

       FROM

[..\Multiple_into_single.xlsx]

(ooxml, embedded labels, table is Sheet1) Group By Id;