Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

Missing value

Linda97
Level 2
Missing value

How can I replace missing value of a column with value of other column using a prepare ?

0 Kudos
1 Reply
JordanB
Dataiker

Hi @Linda97,

You can use a formula step with a coalesce function as shown below. 

Screen Shot 2022-11-07 at 10.54.03 AM.png

I used coalesce(null, "string") where the column with the empty cells is null and the column with the values you want to replace the empty cells with is "string".

Please let us know if you have any questions.

Thanks!

Jordan

0 Kudos