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.
I have been working with Alteryx for 2 years and have been able to automate many workflows, I'm working on a bigger challenge which would be to automate a reconciliation that has a very large database. In the attached file I left a small sample, I'm still searching to find the solution, I'm stuck at a point where I should be able to create some columns next to [Local Currency Amount] basically indicating which values of the lines add up to zero in the "Match column".
I can't execute a routine that deletes rows, it's an audit requirement, so the need to create accessory columns.
I just had a look at the sample data you provided. Do you want to identify pairs of records adding up to zero without any other criterion? I've created a workflow to match by amount (amount to reverse amount) and calculated the matching result based on that. Sample workflow is attached. What do you think?