topic Re: Multiple rows to single row in QlikView

Multiple rows to single row

Fri, 10 May 2013 15:04:26 GMT

Hi,

i have callno and partno and many other fields also which i have loaded in straight table. for a single call no we have multiple partnos which i want to load in a single column and row with inserting a separator how can this be done?

sample:

callno - 2349

partnos-

XXX

rtgh

UUUU

result i want it as :

callno | partnos

2349 | XXX, rtgh, UUUU

Regards,

Grace

Re: Multiple rows to single row

Fri, 10 May 2013 15:18:45 GMT

Load callno, concat(partnos,',') as Allpartnos from tablename

group by callno;

since u've other fields also, u need to group by those fields also

or u can only use this part in a separate load and link to the main table.

depends on which cols u need in ur stght table

Re: Multiple rows to single row

Fri, 10 May 2013 19:09:12 GMT

Thanks, how to do vice versa...

partno

XXX, rtgh, UUUU

i want to load one below the other...

Re: Multiple rows to single row

Sat, 11 May 2013 01:01:59 GMT

what do u mean by one below the other, aren't they already one below the other ?

Re: Multiple rows to single row

nagaiank — Sat, 11 May 2013 01:29:20 GMT

Use SubField() as shown below:

LOAD SubField(partno,',') as IndividualPartNo

from/resident whatever...