Start Free Trial

Alteryx Designer Desktop Discussions

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

Pull back multiple joins from table 2 for each row in table 1

Takizawa
5 - Atom

 

For each row in Table 1, I would like to pull back each of the potentially multiple matches in Table 2. How would I go about doing this in Alteryx?

 

Table 1 - Input

Column 1Column 2

A

1
B2
C3
A4

 

 

Table 2 - Input 

Column 1Column 2

A

42

C

55

A

43

 

Table 3 - Desired output

Column 1

Column 2Column 3
A142
A143
C355
A455
A455
1 REPLY 1
binu_acs
21 - Polaris

@Takizawa Do you want the output of the last two rows of A should be 55? 

Labels
Top Solution Authors