Lookup Table - Lookup function with multiple criteria

Hi all,

I am trying to create a lookup table and then use it as a reference sheet to populate two columns based on multiple criteria in the reference sheet all matching exactly what is in the row of the data table. I have attached a file that explains this a little more clearly.

If anyone knows of a simple way to so this it would be greatly appreciated, thanks!

Alteryx SOP.xlsx

Datasets

Preparation

Accepted answers

LukeG

By default, the Join tool will place all of the fields from the 'Left' table at the beginning and the fields from the 'Right' table will follow. You have the option in the configuration window to select, deselect, reorder, and rename the fields that are included in the output. (As well as change data types)

So, you should have the ability to make the output look just right. If I misunderstood the question, it might be helpful to upload your workflow and I can take a look.

Let me know if you have questions. Thanks!

Luke

All comments

LukeG

Hi @avavalley

It sounds like the Join tool will work in this situation.

Use the two tables as two different inputs. One streaming into the 'L' input anchor, and one streaming into the 'R' input anchor.

Then, select the fields to join on. (Unit, Co Code, Link) Should look something like the picture below.

Let me know if this is helpful, and please ask any questions you may have!

Luke

avavalley

The join tool seems to be putting the reference field in order ie. center, center, center, affiliate, affiliate, affiliate instead of leaving the original order and inserting the matching field.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703