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"

    NULL_IF

    If there is a 'true' boolean value in the 'condition' parameter, then return null. Otherwise, return the value

    Inputs

    • condition
    • value
    condition value result
    true "foo" null
    false "foo" "foo"
    "foo" "foo"