Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Adding columns to sheet when certain data matches from another sheet

nicktekippe
6 - Meteoroid

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.

4 REPLIES 4
atcodedog05
20 - Arcturus

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
6 - Meteoroid

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

DanielG
9 - Comet

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
Alteryx
Alteryx

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:

 

ArtApa_0-1625780215504.png

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

Labels