Replace some values in a column with values from another column

crisdrgmr

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

Miguel Angel

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.

crisdrgmr

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

@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

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