How to Value base on Maximum date for each year

[kalyanpavan1]

Hi Friends,

I am new to alteryx. I have a data like this.

ID Level Date Year
1  A 2012-06-30 2012
2  B 2015-12-18 2015
2 A 2015-01-28 2015

Now I need to take ID Level and year. The Level I should take for ID 2 is maximum data of that year that is B(Since 15-12-18 is older date than 2015-01-28 ).

Please guide me

[jdunkerley79 · Accepted solution]

The easiest way is to use a combination of Sort tool and Sample Tool.

First use a Sort Tool, to order it by ID, Year, Date.

You can then use a Sample tool to take last row of every ID, Year.