Hi Guys, I am having a problem matching records based on 2 criteria in Alteryx.
I have a section codes and a range of distances covered by each section code, and a corresponding value in table 1.xlsx. I want to extract the value from table 1 into another workflow for classification purposes shown in table 2.xlsx.
Table 3.xlsx describes the expected outcome i would like to acheive with the matched values from Table 1 matched (or Null if no match found).
I would usually solve this using an embeded for loop but want to see if theres a better way in Alteryx?
Thank you for any help you can provide.
Ben
Solved! Go to Solution.
Great thank you, this worked.