How to get the last non null row value

[jdbustamantec]

I have the following data:

I need the las date that is not null for each intake. Results for each intake are highlighted

I tried using a sample tool set to Last N rows but it returns the last row including nulls

Any ideas on how to solve this? Thank you

[Luke_C · Accepted solution]

Hi @jdbustamantec 

You could filter out the null rows prior to your sample tool, that should get you what you need. Add a filter tool and filter to Value 'Is Not Null'.

Alternatively based on your data, you could use a summarize tool, group on project and group by Max Value (assuming Value is a Date Time data type). 

[binuacs]

@jdbustamantec One way of doing this with the summarise tool and the join tool