Fill empty cells with previous/next value

[stephC]

Hello,

I'm quite new to Dataiku, and i was wondering how to use " Fill empty cells with previous/next value".in a recepie. I have to ensure my dataset is well ordered, but I cannot find any "processor" that can order my table.

Do you have any clue ?

BR

Stephane

[AlexT · Accepted solution]

Hi @stephC ,

You can use a Sort recipe first https://knowledge.dataiku.com/latest/data-preparation/visual-recipes/concept-sort-recipe.html#concep... 

With a compatible dataset type that keeps order( e.g CSV)

Later modify the output dataset setting and select the option "Preserve Ordering"
Then you should be able to read the dataset you prepare recipe and use the processor "fill empty cells with previous/next value"

Thanks