This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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: