Lookup price based on the bucketed ranges of quantity (VLOOKUP TRUE)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
When I do this in excel it's a Vlookup using TRUE, however I'm unsure how to proceed in Alteryx. I'm trying to lookup the price based on, which bucket the quantity falls into. For example, if I had 26,372 impressions it should return a price of $50. I'm doing this for thousands of transactions.
Solved! Go to Solution.
- Labels:
- Developer
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jvalk005 This can be done in Alteryx, option one is to use the generate rows tool to generate all the numbers between the range, then join with the original file. Sample attached
Based on your data the generate rows tool will more than 100,000 records, another option is to use use the append tool to append your original file with the lookup file then with the formula to check the given number is in the range and return the value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jvalk005 I am going to make a few assumptions, the impression range and price may change and that they may also have irregular intervals (i.e not always 5K.)
I've used append fields to avoid macros but have tested against a sample file of 1.5M Rows and designer seems to be able to handle within its stride.
I hope this helps.
