Join or Union ?

[AhanaR]

Hi Team,

Could someone help me here?

I have two datasets and want to get a combined output from both. In SQL i can write the join query by selecting the required cols from both tables and then joining it on a key. 

How can i apply the same join in Alteryx? i tried to use it , Although I'm able to join the two datasets, my output displays data only from the left dataset.

DataSet 1:

Customer Name	CUSTOMER NUMBER	Material	Revenue	Quantity
ABC	46	AA	2000	7
XYZ	23	AA+	100000	8
BCL	4	BB	8000000	130

DataSet 2:

Region	Material	Billing Qty	Invoice Value (LOCAL)	ASP (Local)
Cambodia	AA	263	106,836.39	406.22
Cambodia	AA+	4	13,868.51	3,467.13
Cambodia	BB	73	6,570.00	90.00

Desired Output :

Customer Name	CUSTOMER NUMBER	Material	Revenue	Quantity	ASP (Local)	Region
ABC	46	AA	2000	7	406.22	Cambodia
XYZ	23	AA+	100000	8	3,467.13	Cambodia
BCL	4	BB	8000000	130	90.00	Cambodia

[binuacs]

@AhanaR Join is an option but you should have a common key in the two datasets to join. I used the material field as the key

[ArtApa]

Hi @AhanaR - You may benefit from our interactive lessons, specifically: https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201

[LeTHo300]

Hi, AhanaR.

Are you able to follow this workflow? And was this helpful?