Alteryx Designer Desktop Discussions

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

Lookup Amount tolerance in Alteryx

griseldagomes
8 - Asteroid

Hi Experts,

 

Need help with looking up amounts upto $1 upwards and downwards, as per data in the Bills file.

2 inputs exist - Bills & Cash Receipt

 

Base file is 'Bills' which needs to be looked up in the 'Cash Receipt' file based on Account and Amount.
However, there should be a tolerance of $1 upwards and downwards while looking up the 'Cash Receipt' file.

 

For example, if the amount in the 'Bills' file is $100.12, the lookup tolerance should be from $99.12 to $101.12
If the match is found, then comment to be updated in the output file is 'Cash Received', else it should be 'Cash Not Received'

 

Thank You

2 REPLIES 2
binuacs
21 - Polaris

@griseldagomes one way of doing this

image.png

griseldagomes
8 - Asteroid

thank you @binuacs 

Labels
Top Solution Authors