Replace some values in a column with values from another column

crisdrgmr
crisdrgmr Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 6

Hi all,

I am trying to replace some of the values in one column (empty ones) with values from another column.

I could do this with Formula, but I do not want to create another column, just want to fill in the blank cells of my column (not all rows of this column are empty) with values that exist in another column.

How can I do this?

Thanks

Best Answer

  • Miguel Angel
    Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
    Answer ✓

    Hi,

    Instead of creating a new column, you can specify with the Formula processor in which existing column to save the output.

    Capture101.PNG

    Conversely, you can also use the create-if-then-else-statement processor.

    Capture1001.PNG

Answers

  • crisdrgmr
    crisdrgmr Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 6

    Hi @MiguelangelC
    thanks for the solutions!

    If, else...processor is missing from my list of processors.

    I have managed to do it using formula, only that instead of to_fill == '', I had to use if(isNull(to_fill))

    Thank you once again!

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,601 Neuron

    @crisdrgmr
    ,

    The create if then else prepare recipe step is a recent additions to Dataiku DSS. This was added in version 11. If you are using an older version of DSS you will not find this.

    https://www.dataiku.com/product/product-updates/

    Second in the prepare recipe I found this step type sort of hard to find. In the prepare recipe step search box, I have to know that the steps searchable name is “Create if then else”. Starting my search with “c” as in Create not “i” as in If.

    Dataiku team could the step search in the visual prepare recipe allow for better searching of this new feature?

  • crisdrgmr
    crisdrgmr Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 6

    @tgb417
    thanks! I guess I'm luck, my Dataiku version just git updated and I know have the Create if, else processor

Setup Info
    Tags
      Help me…