Flag a null value

[renjithpl]

Hi all,

Is it possible to flag as "Null", if in a formula where the numerator or denominator has null value in a straight table. ?

Regards

Renjith

[vishsaggi]

Can you elaborate?

May be like this?

LOAD Numerator,

         Denominator,

          .....,

         IF(ISNULL(Numerator) = -1, 1, 0) AS NumeratorFlag,

         IF(ISNULL(Denominator) = -1, 1, 0) AS DenominatorFlag

From Source;

[felipedl]

Hi Renjith,

You could do something like that in the modeling or by expression.

With the flag you can select the ones that have zero or null values.

Felipe.

[avinashelite]

Try like this

if(len(trim(expression))=0,1,0)