This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
I am currently trying to analyse a large data set of daily payments for individual clients (refer to attached file for a small sample of the data). The goal is to see the last payment date (if any) for each individual client. I have done this in the excel sample (with lookup value formula) and would like to replicate the results in Alteryx, in order to apply to the entire data set.
Any help would be much appreciated. Thank you in advance.
The Transpose tool help to transform the payment dates to rows to determine the total payments and last date. Then those values are joined back to the original data in my attached solution. Let me know if you have any questions.
For future reference, it's actually really easy to open a workflow that's in a newer version of Alteryx than the one you're using.
Simply right click on the workflow before opening it and select 'Edit with Notepad++.' From here, on line two , change the yxmdVer to the version of Alteryx you are using. Save, close, and viola. You should then be able to open the workflow without issues.