Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Match negatives numbers with positive numbers


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?

Alteryx Certified Partner

Hi @Erike ,


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?


Best regards






Perfect! Thank you so much!!