Replace empty value based on condition on another row

magic_mike
magic_mike Registered Posts: 2 ✭✭✭

Hi everyone,

I'm trying to fill empty cells on a database based on the value on another row but I am struggling a bit on this.

Basically I have a time based table where I have empty cells on some days. I would like to fill those cells with the value of the previous day when they happen to be empty (example below).

Input:

DateValue

2020-01-01

1
2020-01-022
2020-01-03
2020-01-043

Output:

DateValue

2020-01-01

1
2020-01-022
2020-01-032
2020-01-043

I know in Excel a simple if + vlookup would do the trick but I can't find a solution on Dataiku...

As my project will be used by "non-coder" colleagues, I'd like to avoid the Python function method and stick to a visual recipe.

Thank you!

Best Answer

Answers

Setup Info
    Tags
      Help me…