Having Alteryx look up from tab B instead if tab A contains a certain value

iteng

Hello Everyone,

I'm new to Alteryx and slowly developing my skillset. What I'm trying to accomplish using Alteryx is having it look for a description of "XXX" in column E on input's tab 1, if it's true, then return whatever shows in column F on input's tab 2 if columns A & B & C on both tabs are the same. I'm thinking about using the Join function but not sure how to set it up exactly. Any solution or suggestions would be much appreciated!

Raj

You can achieve this by using the "Join" tool in Alteryx Designer. Here's how you can set it up:

1. Connect your two inputs to the "Join" tool.
2. In the "Join" tool, set "Tab 1" as the primary input and "Tab 2" as the secondary input.
3. For the join condition, select the option "Join on specific fields".
4. In the join fields, add three fields from "Tab 1" (Columns A, B, and C) and three fields from "Tab 2" (Columns A, B, and C) to form the join condition.
5. Set the join type to "Inner Join".
6. In the "Join" tool, add a filter condition to look for the description "XXX" in column E of "Tab 1".
7. Finally, add an output field to return the values in column F of "Tab 2" if the join condition and filter condition are true.

This should give you the desired result. Note that the steps and terminology may vary slightly based on the version of Alteryx Designer you are using.