Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you want replace Zeros by Nulls?
Load If(ColA<>0,ColA) As ColA, ... From Table
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