topic Re: Multiple row into single row in QlikView

Multiple row into single row

Thu, 28 Feb 2013 06:15:12 GMT

Hi All,

I have table like the following :

CustomerID	ConnectionCode	KidName1	KidName2	KidName3
C01	1	Name1
C01	2	-	Name2	-
C01	3	-	-	Name3
C02	1	Name1	-	-

Is there a way in load script so I can create Table Box like this :

CustomerID	KidName1	KidName2	KidName3
C01	Name1	Name2	Name3
C02	Name1	-	-

Thanks

Re: Multiple row into single row

hic — Thu, 28 Feb 2013 09:40:02 GMT

Yes, you can do the following:

Load CustomerID, KidName1 From ... Where Len(Trim(KidName1))>0 ;

Join Load CustomerID, KidName2 From ... Where Len(Trim(KidName2))>0 ;

Join Load CustomerID, KidName3 From ... Where Len(Trim(KidName3))>0 ;

and this will create exactly the table that you want. The problem is however, what you should do with your ConnectionCode. It is not clear to me how you want to load this.

HIC

Re: Multiple row into single row

Thu, 28 Feb 2013 11:51:45 GMT

Hi Henric

Many Thanks. Your solution is works.

Best Regards,

Heri Setiawanto