how do i check if a future value has changed

[Fquinn]

Hi,

I need to read data and see if a value has changed later on down the file and add it to a new column, i can check if a previous or next row has been modified but would like to check all the rows

Name	workerID	Date	Workplace
john doe	1	Jan	home
john doe	1	Feb	home
john doe	1	Mar	home
john doe	1	Apr	office
mr man	2	Jan	home

Expected outcome

Name	Worker ID	Date	Workplace	current workplace
john doe	1	Jan	home	office
john doe	1	Feb	home	office
john doe	1	Mar	home	office
john doe	1	Apr	office	office
mr man	2	Jan	home	home

[FinnCharlton · Accepted solution]

Hi @Fquinn , here is one way to do this:

• First we parse the month names into dates to allow sorting.
• We then sort by Worker ID and Date to ensure the correct order.
• We then use the Sample tool to take the final row of each Worker. This corresponds to the most recent month.
• Lastly, we join this back onto the original dataset.

Hope this helps!

[PhilipMannering · Accepted solution]

As long as the dates are sorted in chronological order you can do,

[Fquinn]

thanks both, tested with the sample method and works perfectly