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!
Solved! Go to 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!
Thank you very much! This absolutely solved my issue.