Index Match Data from a Table

[Terry_Hoskins]

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!

[DataNath · Accepted solution]

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!

[Terry_Hoskins]

Thank you very much! This absolutely solved my issue.