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!
