Discover the winners & finalists of the 2022 Dataiku Frontrunner Awards!READ THEIR USE CASES

Dataiku Equivalent for SAS Retain

anthony
Level 2
Dataiku Equivalent for SAS Retain

Is there a step or transformation within Dataiku that can be used as an alternative to the Retain step in SAS.  In simple form SAS Retain step remembers the value of a particular column from a previous row and populates that in the current row

0 Kudos
1 Reply
Manuel
Dataiker Alumni

Hi,

You can use a window recipe and the lag (or lagdiff) aggregator, which enables you to pull a value from a previous row.

Here is a video from our academy on the Window recipe: https://videos.dataiku.com/watch/N6GxBuLhAZuQ6wgV8zR53r?

I hope this helps.