This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In Alteryx is it possible to create lead or lag functions where it can take the previous field from another row and add it as a field to its row as seen below. I want to make an end date to my data for the user to understand which record was active during a specific point in time
LAG() OVER PARTITION(UNIQUE ID ORDER BY ...)
Raw Data Unique Id Start Date 234 20140101 456 20151001 456 20161201 789 20151001 789 20161101
Derived data Unique Id Start Date End Date 234 20140101 99991231 456 20151001 20161130 456 20161201 99991231 789 20151001 20161031 789 20161101 99991231
I am trying to replicate the functionality on my dataset that contains the following data :
The data has multiple records for every KEY_NO,MO_YR_KEY_NO combinations. I want to get the BONUS_LEVEL for the next MO_YR_KEY_NO but not the next row.I am attaching a sample data set(sample csv) and my workflow with the required values.It would be great if someone can help me this.