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 1 | Column 2 |
A | 1 |
B | 2 |
C | 3 |
A | 4 |
Table 2 - Input
Column 1 | Column 2 |
A | 42 |
C | 55 |
A | 43 |
Table 3 - Desired output
Column 1 | Column 2 | Column 3 |
A | 1 | 42 |
A | 1 | 43 |
C | 3 | 55 |
A | 4 | 55 |
A | 4 | 55 |
@Takizawa Do you want the output of the last two rows of A should be 55?