How do I take the most recent value from the same dataset for three partitions

Noah

Say I have data like where some of the keys change. How do I get dataiku to return the MOST RECENT for a rolling three month period. The dataset above assumes they are stacked and sorted, but perhaps before I stack them we could use something like a window recipe.

Thanks!

I think I can do this by grouping and ranking OR a windows recipe. I am currently experimenting with a windows recipe.

Noah

I used a windows recipe . I set partitioning column to "Name and order column to "Partition" (data was enriched to have the partition as a column to get the date). I sorted by descending and post filtered to rank == 1. I retrieved all the fields in the recipe.