The Dataiku Frontrunner Awards are now accepting submissions until July 15 to recognize your achievements! ENTER YOUR SUBMISSION

Dataiku Equivalent for SAS Retain

anthony
Level 2
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
Dataiker

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.

 

A banner prompting to get Dataiku DSS
Public