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
Solved! Go to Solution.
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:
If this isn't working, could you email a sample of your data to support@alteryx.com?
Thanks!
Chad
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..!!!