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

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

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



 

Mattsco

Labels

?
Labels (2)
A banner prompting to get Dataiku