Issue related to Joins

[Katiewen]

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

[CathyS_Slalom]

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)

[binuacs]

@Katiewen