Matching Two criteria from Other data souce

[bwyeth]

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

[Qiu · Accepted solution]

@bwyeth 

We can either use Append or Join to achieve it. here is a sample of Append.

[Qiu]

@bwyeth 

Join tool version

[bwyeth]

Great thank you, this worked.