topic Re: Concatenate same fields from different rows in QlikView

Concatenate same fields from different rows

Fri, 29 Jun 2012 03:47:38 GMT

Hello,

I have a table containing these information

Num , Value

1 , A

1, B

2 , V

3, A

3 , D

4 , E

I would like to create a table with the following fields

Num Value

1 , A|B

2 , V

3 , A|D

4 , E

any idea ?

The data source is an SQL server 2008 Database.

Thanks for your help

Philippe

Re: Concatenate same fields from different rows

Anonymous — Fri, 29 Jun 2012 03:52:03 GMT

Hi Philippe,

You might want to look at using the Concat() function. Here's an inline example based on your data:

T1:

LOAD * INLINE [

Num , Value

1,A

1,B

2,V

3,A

3,D

4,E

];

NoConcatenate

T2:

Load

Num,

Concat(Value,'|') as Value

Resident T1

Group by Num;

Drop table T1;

Re: Concatenate same fields from different rows

Fri, 29 Jun 2012 11:34:34 GMT

Thanks a lot.

I always forgot that function.

That works perfectly,

Philippe