Hi guys,
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.
Does anyone here have any ideas?
