community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Match negatives numbers with positive numbers

Highlighted
Meteoroid

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

 

Roland

10-10-_2019_17-32-25.png

Meteoroid

@RolandSchubert 

Perfect! Thank you so much!!

Labels