Hi,
I am trying to join 2 tables in alteryx, Table 1 has many more fields but I am trying to join the two tables on the basis of NumberID and Order. I have tried using join but I was not to able to get the desired output.
Table 1
Date | NumberID | Order | Area |
1 Jan 2021 | 123 | 23 | West |
3 Jan 2021 | 123 | 35 | East |
6 Jan 2021 | 123 | 50 | North |
1 Jan 2021 | 234 | 23 | West |
4 Jan 2021 | 234 | 35 | South |
Table 2
NumberID | Order | Item |
123 | 35 | 1 |
123 | 35 | 2 |
123 | 35 | 3 |
123 | 35 | 4 |
123 | 35 | 5 |
234 | 23 | 1 |
234 | 23 | 2 |
234 | 23 | 3 |
234 | 23 | 4 |
Desired Output
Date | Number ID | Order | Item | Area |
3 Jan 2021 | 123 | 35 | 1 | East |
| 123 | 35 | 2 | East |
| 123 | 35 | 3 | East |
| 123 | 35 | 4 | East |
| 123 | 35 | 5 | East |
1 Jan 2021 | 234 | 23 | 1 | West |
| 234 | 23 | 2 | West |
| 234 | 23 | 3 | West |
| 234 | 23 | 4 | West |
Hi @Katiewen, see attached workflow. You can join on Number ID and Order to achieve this (deselect overlapped columns and reorder the column to the order you want to see)