Replace some values in a column with values from another column
![crisdrgmr](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar22.png)
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 Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
Hi,
Instead of creating a new column, you can specify with the Formula processor in which existing column to save the output.
Conversely, you can also use the create-if-then-else-statement processor.
Answers
-
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 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,598 Neuron
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?
-
@tgb417
thanks! I guess I'm luck, my Dataiku version just git updated and I know have the Create if, else processor