Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Henric
Many Thanks. Your solution is works.
Best Regards,
Heri Setiawanto