Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Multiple row into single row

Hi All,

I have table like the following :

CustomerIDConnectionCodeKidName1KidName2KidName3
C011Name1

C012-Name2-
C013--Name3
C021Name1--

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

CustomerIDKidName1KidName2KidName3
C01Name1Name2Name3
C02Name1--

Thanks

1 Solution

Accepted Solutions

Re: Multiple row into single row

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

2 Replies

Re: Multiple row into single row

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

Not applicable

Re: Multiple row into single row

Hi Henric

Many Thanks. Your solution is works.

Best Regards,

Heri Setiawanto