If else condition

[prma7799]

Hi All,

I have table like below

ColA  ColB ColC ColD

1        0          0     0

0        1          0     0    

0        0          1     0    

0        0          0     1

and I want output like   

ColA  ColB ColC ColD

1                        

         1                     

                    1          

                          1

How to achieve it?

Thanks

PM

[anbu1984]

Do you want replace Zeros by Nulls?

Load If(ColA<>0,ColA) As ColA, ... From Table

[NareshGuntur]

Try this

LOAD Replace(A,0,'') as A,

Replace(B,0,'') as B,

Replace(C,0,'') as C,

Replace(D,0,'') as D

from XXX;

Cheers,

Naresh