Replacing null values in a column

[JMorrison619]

I have two columns side by side. The first column has a numerical value in every cell. The second column has values in only some cells and null in the cells without values. I'm trying to create a third conditional column that (1) takes the higher of the two numbers in each row (if two numbers are available to compare) or the number from the first column if there is a null value in column next to it. I've tried using the "Conditional Column" tool but don't know how to reflect a conditional statement with a null value. Any help is much appreciated.

Thanks,

Jimmy

 

[shuyin]

you can go to the Advance editor and change the code to be: if [2nd column] = null then [1st column] else if [2nd column] > [1st column] then [2nd column] else [1st column]

OR before doing the conditional statement, you use "Replace" null by 0, then start comparing.

Br, T

 

[JMorrison619]

Thank you, that worked nicely.