Select the second field value if the first field value is null

[mdmukramali]

Dear ,

i want to create a new field which contains A values, if any place A value is missing (Null) then it should select the value from second  B field.

i don't remember the function for it.

example:

a:

LOAD * Inline

[

A,B

1,

,4

2,3

6,2

]

;

LOAD * ,

{FUNCTION} (A,B) AS NewField

Resident a;

DROP Table a;

OUTPUT:

NewField

1

4

2

6

Thanks,

mukram

[Anonymous]

Got it