if statement with isnull in INDB formula

Question

Hi All,

Can some one help me with INDB formula.

Create a new column with below condition

if Column A is null then take Column B else Column A end

i tried with below formula but it did not work.

if isNull("A")
then "B"
else "A"
end

fmvizcaino · Accepted Answer

Hi @Shank ,

Which Database are you connecting into?

You can try this two examples:

mySQL: IFNULL([A], [B])

SQL Server: isNULL([A], [B])

https://www.w3schools.com/sql/sql_isnull.asp

Best,

Fernando Vizcaino