How to append/join fields from one table to another table?

[ruidijnj]

Hi,

I have two tables (Table A and Table B) and could someone show me how I can append/join Purchase Date from Table B to Table A? The connection key between the two tables are Transaction ID and Order ID. One thing to note is Table B doesn't have all the same lines from Table A, so I can't just simply copy the Purchase Date column from Table B and paste to Table A. 

Table A

Transaction ID	User Name	Country	Amount
1467	A.A.	CA	$10
2903	B.B.	US	$18
3551	C.C.	UK	$30
4680	D.D.	BR	$25
1007	E.E.	CN	$51
2365	F.F.	JP	$12

Table B

Order ID	Purchase Date	Ship Date
1467	1/1/2024	1/2/2024
4680	1/5/2024	1/7/2024
2365	1/6/2024	1/6/2024

Thank you!

[Fizzledrizzle · Accepted solution]

Howdy! 

I believe what you are looking for is the Join tool where you could join Table A and Table B together. 

 Join Tool (alteryx.com)

Join Example

if you need everything on Table A and any information from table B if it exists, then you can union the Left and Join together (in the above example)

 Union Tool (alteryx.com)

Join with Union