The Dataiku Frontrunner Awards have just launched to recognize your achievements! Submit Your Entry

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

Mattsco
Dataiker
Dataiker
 
Mattsco
0 Kudos
1 Reply
Mattsco
Dataiker
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
A banner prompting to get Dataiku DSS