How to get the last non null row value

Question

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 Answer

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).