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?
