Replacing null values in a column

JMorrison619

New member
Joined
Dec 13, 2016
Messages
4
Reaction score
0
Points
0
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
 
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
 
Back
Top