Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Index Match Data from a Table

Terry_Hoskins
5 - Atom
‎05-26-2022 01:02 PM

Trying to create an Index Match in Alteryx to match the function in the attached Excel file. We have rates that are weight/mileage specific and looking to populate the correct rate in thousands of lines of data. Any assistance is greatly appreciated!

Preview file
20 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
DataNath
17 - Castor
‎05-26-2022 01:24 PM

Hey @Terry_Hoskins, how does this look? Basically pivots the reference table and then matches the incoming records to their corresponding weight/mileage band. Any issues let me know and I'll revisit!

 

DataNath_0-1653596624073.png

 

Index match.yxmd
Reply
0 Likes
Terry_Hoskins
5 - Atom
‎05-26-2022 02:24 PM

Thank you very much! This absolutely solved my issue. 

Reply
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels