SOLVED
Lookup Amount tolerance in Alteryx
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
griseldagomes
8 - Asteroid
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Designer Cloud
2 REPLIES 2
binuacs
21 - Polaris
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@griseldagomes one way of doing this
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you @binuacs
