Null values script

[Anonymous]

Hi,

I have a field "Saksnr" that contains null values and some of the collums has numeric values.

I want to sort this out like this:

is not null values = "Purret"

and

isnull values = "Inkasso"

rename the field to Status, and use it as a listbox for selection between "purret" and "inkasso".

[annafuksa1]

try

if(isnull(Saksnr), 'Inkasso','Purret') as Status

[sunny_talwar · Accepted solution]

May be like this:

LOAD Saksnr,

          If(Len(Trim(Saksnr)) = 0, 'Inkasso', 'Purret') as Status,

          ...

FROM ....;

[Anonymous]

Perfect ! Thanks 🙂