Problem:
I have a dataset of AP Payments I am trying to clean up in Alteryx. One of the requested items is to call out possible duplicated payments. There are no unique records recorded in our AP input software and the list comes out like the following:
Im wanting to use Alteryx to look for possible records based on the following Group By:
- Vendor/ID
- Payment Date
- Payment Type
- Check #
- Amount Due
- Net Amount
The hopeful outcome would look something similar to below:
I color coded the potential Duplicated records just to make it easier to see the results. Basically the logic would look for records with the same fields:
- Vendor/ID
- Payment Date
- Payment Type
- Check #
- Amount Due
- Net Amount
I have done something to this in SQL with LEAD and LAG and it looks like Multi-Row Formula Tool in Alteryx can accomplish this goal, I am just not sure how to set up the tool to get the desired results. I have created a sample YXMD workflow with the sample data above.
Thank in advance for any input or help.
