Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Lookup / Join Tool Multiple Fields

kpurcell
6 - Meteoroid

Hello,

Not sure if this is a simple item but was hoping to get a recommendation on a tool to help assign if an item is taxable or not based on a state and item code match.  For example,

Table 1 has transaction data including the following key fields:

Customer
State
Item Code
Sales

Table 2 has taxbility by state and item code and has the following fields:

State
Item Code
Taxability

What I need to have happen is for each state and item code in table 1 return if an item is taxable by looking up state then item code and return as an additional field in table 1 the taxability.

I have tried both the Join Tool and the Join Multiple tool with the Left/Input 1 first being state from table 1 Right/Input 2 state from table 2.  Added an additional join line for item code as well.

When trying each, I am not getting many matches.  Anyone have a recommendation if this is possible and the best tool?

Thanks in advance for any help,

Kevin

5 REPLIES 5
ChadM
Alteryx Alumni (Retired)

Hi Kevin,

If you are joining two state fields and are getting no matches, I would first add a Browse Tool to each Left and Right outputs of the Join Tool, then compare the two fields visually.  Questions I have are:

  1. Are there additional spaces in the field values?  
  2. Are the two State fields different, with one being "Colorado" and one "CO"? (full state name vs. abbreviation)

If this isn't working, could you email a sample of your data to support@alteryx.com?  

Thanks!

Chad

shashi_lingaiah
5 - Atom
Hi Kevin,

Another thing to keep in mind is that Join tool is case sensitive. If you have "Colorado" in input1 and "COLORADO" in input2, it does not satisfy the join condition. In that case, you can add a formula tool before joiner tool to change everything into uppercase.

Regards,
Shashi
kpurcell
6 - Meteoroid
Thanks everyone.  It was a data issue.

Apprecite the help.

Kevin
VersionWeekly
5 - Atom

Thanks ........................

love this 

 

I am a contributor to https://versionweekly.com/

jasminp14
5 - Atom

Thanks for sharing..!!!.

I hope Celebrity's Net Worth will help you with information about your favorite person.  Good Luck with the upcoming update. You’re doing a great job...Keep it up..!!!

 

Labels