MAXIF solution using Alteryx

[robin2021]

Hi all

I have a data table which details an account number, the last review date and whether the review was manual or automatic.

I'm trying to use Alteryx to analyze the data to produce an output which shows the last time an account was manually reviewed. If the account hasn't been manually reviewed I would like to see the last time it was automatically reviewed.

Any help on this would be really appreciated....

Output data:

Account no	Last review	Review type
1	Apr-23	Man
2	Mar-23	Man
3	Mar-23	Auto

Input data:

Account no	Last review	Review type
1	Aug-22	Man
1	Feb-22	Auto
1	Apr-23	Man
1	May-22	Auto
1	Nov-22	Man
1	Nov-21	Auto
1	Feb-23	Auto
1	Jan-23	Auto
2	Mar-23	Man
2	Nov-21	Auto
2	Dec-22	Man
2	Nov-22	Auto
2	Nov-21	Auto
2	Jan-23	Auto
3	Oct-22	Auto
3	Aug-22	Auto
3	Feb-23	Auto
3	Nov-22	Auto
3	Dec-22	Auto
3	Mar-23	Auto

Thank you!

[FrederikE]

Hey @robin2021,

This should do.

[robin2021 · Accepted solution]

Perfect - thank you very much!