In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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