inter-rows computations

Options
AdhiThibu
AdhiThibu Registered Posts: 4 ✭✭✭✭

Hi Dataikers!

I want to know if there is a way in visual recipes to use the value from the previous row to compute the next row and do it iteratively to cover the whole column?

I'm sure It can be done in python but I want to know about Dataiku.

Thank you!exx.PNG

Answers

  • HarizoR
    HarizoR Dataiker, Alpha Tester, Registered Posts: 138 Dataiker
    Options

    Hi,

    You can use the Window recipe and generate a "lag" column that will take the "previous" value of another column with respect to an ordering column you will specify (in your case, probably Group_ID).

    You can find a more detailed example of the Window recipe here.

    Best,

    Harizo

Setup Info
    Tags
      Help me…