straight table

[raadwiptec]

Hi All,

my expression values for a column is 0.00000 and some are null.

I need a condition in the expression where if the column is null or 0.0000 then populate the value from another column

ex

price ¦ net

0.00000 ¦ 1.24

0.00000 ¦ 1.25

null ¦ 1.26

my expected output should be..so if the price value is null or 0.0000 then it should take value from the net column

price ¦ net

1.24 ¦ 1.24

1.25 ¦ 1.25

1.26¦ 1.26

[sunny_talwar]

May be this:

If(price = 0 or Len(Trim(price)) = 0, net, price)

[MarcoWedel]

Hi,

one solution could be:

SET NullInterpret='null';

table1:
LOAD If(price,price,net) as price,
    net
INLINE [
    price, net
    0.00000, 1.24
    0.00000, 1.25
    null, 1.26
    0.00001, 1.27
    10, 1.28
];

hope this helps

regards

Marco