Id like to ask the Alteryx community for some ideas please to help replicate some functionality that exists in another app I have, but in Alteryx.
In an app I have a table, where data is passed through row by row to establish outcomes. Within the table, if the data meets certain criteria, then a logical IF statement is run at the end, to provide the output, also, there are some simpler lookups, like if the input value is A, then output B, etc.
I can't seem to find a lookup function within Alteryx using a reference table. Want I want to avoid is using the 'formula' tool, and just having many rows of IF statements to do what I need. Can anyone help with simple ideas to approach this sort of scenario?
Solved! Go to Solution.
You'll need the Join tool. It serves like a VLOOKUP for your scenario.
This link will help: https://knowledge.alteryx.com/index/s/article/Alteryx-for-Excel-Users-How-to-do-a-VLOOKUP-in-Alteryx....
In Alteryx Designer, you can achieve the functionality you described using various tools and workflows. While Alteryx might not have a direct lookup function like some other tools, you can use the Join tool or the Multi-Field Formula tool to accomplish similar tasks. Here are a few ideas:
1. Join Tool for Lookup:
2. Multi-Field Formula Tool:
3. Filter Tool for Conditional Logic:
4. Filter and Formula Combination:
5. Use the Formula Tool for Simple Conditions:
thanks for sharing.. i think i need a combination of filters and joins. thanks for your help