Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

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
16 - Nebula

@bwyeth 

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

0224-bwyeth.PNG

Qiu
16 - Nebula

@bwyeth 

Join tool version

0224-bwyeth-1.PNG

bwyeth
5 - Atom

Great thank you, this worked. 

Labels