Search results

    Edit on GitHub

    COALESCE

    Returns the first value that is not null or missing

    inputs result
    "Foo" "Foo"
    "Foo", "Bar" "Foo"
    null, "Foo", null, "Bar" "Foo"
    "Foo", null, "Bar" "Foo"

    IF_ELSE

    If there is a 'true' boolean value in the 'condition' parameter then return the first value else the second

    Inputs

    • condition
    • true_value
    • false_value
    condition true_value false_value result
    true "foo" "bar" "foo"
    false "foo" "bar" "bar"
    "foo" "bar" "bar"