Adding columns to sheet when certain data matches from another sheet

[nicktekippe]

I am using the Join tool to add two columns of data to the original sheet by matching the part numbers from both sheets of data. The result that I want is the 5041 rows of data from the original sheet with the supp. # and supp. name columns added from the second sheet but it is resulting in 50k+ rows of data after running the tool. If anyone knows a better way to add these columns or a fix so the join tool does what I am intending I would appreciate it.

[atcodedog05]

Hi @nicktekippe 

This clearly happening because of many to many join. The join key combination selected should be unique in at least one of the data source.

[nicktekippe]

@atcodedog05 What if I cannot make one of them unique?

[DanielG]

hi @nicktekippe Can you explain your data a bit more, or give a generic sample of each table?

What are the 2 tables and why isnt one of them a "parts table" with a unique ID for each part.

It doesnt make sense to try and connect two tables that both have non-unique IDs.

[ArtApa · Accepted solution]

Hi @nicktekippe - It would be great to understand your data and requirements little bit better. However, without this I'd recommend you to consider a Find Replace tool. Have a look at Examples and see if the tool will work for you:

Link: https://help.alteryx.com/current/FindReplace.htm