ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MST. Please plan accordingly.

Alteryx Designer Discussions

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

Matching Two criteria from Other data souce

bwyeth
5 - Atom

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
17 - Castor

@bwyeth 

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

0224-bwyeth.PNG

Qiu
17 - Castor

@bwyeth 

Join tool version

0224-bwyeth-1.PNG

bwyeth
5 - Atom

Great thank you, this worked. 

Labels