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.
