Hello All,
I have attached the below snapshot of how my raw data looks like and what I need as Output. Can someone please help me as to how do I achieve this? Thanks.
A normal Join tool will do this. Assuming all employees in the Sales Table are in the Employees table the J output will have what you want.
It is a good idea to verify you haven't lost records from the Sales table. You can use a Test tool to do this.
Sample attached
Hi - thank you for your reply.
I tried running your workflow as it is and it gives an error in the snapshot below.
Moreover, i had tried creating a similar workflow for my data, but the output in the J is significantly larger than any of the two inputs. I read through this article https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-the-Join-Tool-Works-and-Why-You-Might-Be-Getting-More/ta-p/22581 to understand that one of my inputs has duplicate entries for the column that I am joining on, but I couldn't understand the solution.
My workflow is as below: The "Browse (5)" tool is my J output - record count is much much larger than what I expected.
