Multiple row into single row

[#1]

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

[hic · Accepted solution]

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

[#3]

Hi Henric

Many Thanks. Your solution is works.

Best Regards,

Heri Setiawanto