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

Highlighted
Mattsco Dataiker
Dataiker
How can I fill in empty cells of a column with values of the corresponding rows from another column?
 
0 Kudos
1 Reply
Mattsco Dataiker
Dataiker
Re: How can I fill in empty cells of a column with values of the corresponding rows from another column?

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



 

0 Kudos
Labels (2)