Discussion Board for collaboration on QlikView Scripting.
I have table like the following :
Is there a way in load script so I can create Table Box like this :
Go to 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.
Many Thanks. Your solution is works.