How can I fill in empty cells of a column with values of the corresponding rows from another column?

Mattsco
Mattsco Dataiker, Registered Posts: 125 Dataiker

Answers

  • Mattsco
    Mattsco Dataiker, Registered Posts: 125 Dataiker

    In a preparation script, use the processor Formula with the coalesce function :

    The function can work with multiple columns:

    coalesce(null, null, "string") -> "string"

    Matt

Setup Info
    Tags
      Help me…