Replace some values in a column with values from another column

Solved!
crisdrgmr
Level 2
Replace some values in a column with values from another column

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

0 Kudos
1 Solution
MiguelangelC
Dataiker

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

View solution in original post

4 Replies
MiguelangelC
Dataiker

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

crisdrgmr
Level 2
Author

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?  

--Tom
crisdrgmr
Level 2
Author

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