Missing value

Linda97
Linda97 Registered Posts: 4 ✭
in Using Dataiku

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

· Share on FacebookShare on Twitter

Answers

  • JordanB
    JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 296 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

     

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…